The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
Reload this Page passing value to a variable in a SQL
Google UNIX.COM
Forums Directory Register Forum Rules FAQContribute Members List Search Today's Posts Mark Forums Read



Thread: passing value to a variable in a SQL
View Single Post in UNIX Forums - Click on the Thread or Permalink to View Entire Thread -->
  #5 (permalink)  
Old 08-30-2007
jscott jscott is offline
Registered User
  

Join Date: Apr 2005
Location: Bowling Green, KY
Posts: 1
I am not sure if this helps, but I pass vars from ksh script to oracle sql scripts using the following....

sqlplus -s $DBUSER/$DBPASS @my.sql > output.txt $SHELLVAR;

Then from within my.sql file I reference the input var with '&1'.
Reply With Quote