Re: Dynamic variables within unix script file...

>Simply changing the line containing your select statement to:
 

>select * from table_name where emp_num = $1;
 

>should do the trick. The Unix shell will substitute the $1 with the
>first parameter you give in, before passing the command to SQL*Plus.

What do you do if the parameter you pass is text with embedded spaces and the number of spaces varies. For instance, the input might be 1 to 5 words for a 'name' parameter...

   George Earl Jones
   George Jones
   George Earl Jones, III
** Brian.Sakach_at_DaytonOH.NCR.COM ** Received on Mon Jan 10 1994 - 19:31:47 CET