Learning Linux Shell Scripting - Second Edition

Inserting the data into table

Now we will insert some data into our Writers table. We will be using insert into query to insert the data. Create a script oracle_04.sh to insert the data:

#!/bin/bash 
sqlplus user1/Test123 <<MY_QUERY 
set serveroutput on; 
INSERT INTO Writers VALUES(101, 'ABCD'); 
INSERT INTO Writers VALUES(102, 'EFGH'); 
INSERT INTO Writers VALUES(103, 'IJKL'); 
INSERT INTO Writers VALUES(104, 'MNOP'); 
INSERT INTO Writers VALUES(105, 'WXYZ'); 
MY_QUERY 

Save the script and run it as follows:

          $ chmod +x oracle_04.sh
          $ ./oracle_04.sh
  

The output will be:

    SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 30 18:02:13 2018
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Connected to:
    Oracle Database 11g Enterprise Edition ...