Learning Linux Shell Scripting - Second Edition

Retrieving data from a table

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: ...