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