Home -> Usenet -> comp.databases.oracle -> Dynamic variables within unix script file...

Dynamic variables within unix script file...

From: <rutkowski_at_force.ssd.lmsc.lockheed.com>
Date: Thu, 6 Jan 1994 22:02:59 GMT
Message-ID: <CJ8AL0.E47_at_butch.lmsc.lockheed.com> 








Can somebody help me!!!!



I'm trying to pass a variable into a unix script to be used as a 
selection critira in a oracale SELECT statement and I'm not sure 
how to do this.  My script file look like this:






sqlplus login/password << end_select



select * from table_name where emp_num = 21;



end_select





This script works and displays the employee information for the 
employee with employee_number = 21 but how can I make 21 a dynamic 
variable so I can run this from a unix prompt and pass in a value?



$ script_name 21


$ script_name 101


     .

     .

     .




My thanks in advance!!!!!!!!   



Steve Rutkowski (DEL-LMSC) 303-739-4688	or email.
    
Received on Thu Jan 06 1994 - 23:02:59 CET












Original text of this message