Learning Linux Shell Scripting - Second Edition

Drop the table

If we want to remove a table along with its definition, data, and partitions, then we need to use the DROP command. This command will delete complete table along with its data and partitions information.

Now we will create a script oracle_08.sh to drop the table:

 
#!/bin/bash 
 
sqlplus user1/Test123 <<MY_QUERY 
set serveroutput on; 
 
drop table Writers; 
select * from Writers; 
 
MY_QUERY 

After executing this script, your table gets deleted. We have written the select statement to check whether the table gets deleted or not.

Save the script and run it as follows:

          $ chmod +x oracle_08.sh
          $ ./oracle_08.sh
  

The output will be:

    SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 30 18:15:53 2018
    
    Copyright (c) 1982, 2009, Oracle. All ...