SHELL和SQL Script

botang

1. #!/bin/sh
   
2.   
   
3. read -p "PLS INPUT THE ORACLE PASSWORD FOR HR: " PASS
   
4. echo $PASS
   
5. export ORACLE_BASE=/u01/app/oracle
   
6. export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
   
7. export ORACLE_SID=rcat
   
8. 
   
9. 
   
10. /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlplus hr/$PASS <<EOF
    
11. @/home/oracle/1.sql;
    
12. EOF
    

复制代码

1. set linesize 1000
   
2. 
   
3. select  * from employees;
   
4. 
   
5. set serveroutput on
   
6. 
   
7. begin
   
8.   dbms_output.put_line('Hello World.');
   
9. end;
   
10. /
    

复制代码