Re: Piping from Unix to SQL*Plus

venkat_rajagopal_at_my-deja.com allegedly wrote:

> Hi,
>
> I've got a problem. I want to pipe a file ( all sql*plus commands
> inside the file ) to sqlplus .
>
> cat filename | sqlplus -s /
>
> is ok but won't work for me because in my file 'filename'
> I have '&&' specified in order to accept user input.
> The above method is ok if I don't have the need for user input.
> How can I do this? You might be wondering why on earth I need it
> but I really do. Let me know if you guys have any suggestions
> and If needed and you so desire I will give you more details.
>
> Thanks
>
> Venkat
>
>
> Sent via Deja.com
> http://www.deja.com/

If these are all commands in the file, just do a:

   sqlplus user/passw_at_dbsid @filename

and stand back and watch it go.

-- 
Chris Kasten
icq# 7603936
http://www.kastenracing.com/chris/