The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Running SQL Scripts from Shell script - Need insight!
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Running SQL Scripts from Shell script - Need insight!
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #2 (permalink)  
Old 06-28-2006
tmarikle tmarikle is offline Forum Advisor  
Registered User
  
 

Join Date: Jan 2005
Posts: 683
Try this syntax:
Code:

conn="user/pwd@service_name"
sqlplus -s $conn <<EOF1
@xyz.sql
@pqr.sql
@abc.sql
EOF1