To retrieve data from a table, we use the select statement. We can retrieve all of the records from a table, or we can retrieve a specific record using select statement.
To retrieve all of the records from the table, we use * in the select statement. So the query will be as follows:
select * from table_name;
Create the script oracle_05.sh to get all of the records from the table:
#!/bin/bash sqlplus user1/Test123 <<MY_QUERY set serveroutput on; select * from Writers; MY_QUERY Save the script and run as follows: $ chmod +x oracle_05.sh $ ./oracle_05.sh
The output will be:
SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 30 18:05:36 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: ...