If we want to delete single or multiple rows from a table, then we need to use the DELETE command. We can delete single or multiple rows at a time. This is useful for deleting obsolete data.
Now, create the script oracle_07.sh to delete the record:
#!/bin/bash sqlplus user1/Test123 <<MY_QUERY set serveroutput on; DELETE FROM Writers WHERE Name = 'demoname'; select * from Writers; MY_QUERY
Save the script and run it as follows:
$ chmod +x oracle_07.sh $ ./oracle_07.sh
The output will be:
SQL*Plus: Release 220.127.116.11.0 Production on Mon Apr 30 18:11:07 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, ...