How to execute a .sql file with shell script

Shell Programming and Scripting
1

hi everybody...
can anyone help me in executing the .sql file with shell scripting....

thanx in advance

2

Connect to sqlplus and then execute it as belows if your sql file is just a Declare begin end SQL block:
#!/bin/csh

set db_login = <database user>@<connectstring>/<database passwd>

sqlplus -s $db_login << eof_disp > log_file_$$.log
@<file path>/<filename>
eof_disp

Hope this helps

3

giving an example here..

#! /usr/bin/ksh

set -x
ORACLE_HOME=/u101/app/oracle/product/8.1.7
export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
PATH=$PATH:/usr/ccs/bin:/usr/bin/bin:/opt/bin/usr/sbin:/$ORACLE_HOME/bin:.
export PATH
ORACLE_SID=SVM_WL1
export ORACLE_SID
sqlplus / @/svm_wl1/billing/work/svm_wl1/abhijeet.sql
---------

create a file ,feed in the terms,make it shell executable & excute it...

regards
abhijeet