Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Piping from Unix to SQL*Plus
In article <0ulh6tc6p2vom94havlkfh8vpc7peqhmv3_at_4ax.com>,
kasten_at_pobox.com wrote:
> 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
Chris,
That is the most obvious but I cannot use that in my case. I have a design need for Unix output to be piped to sqlplus when the file contains SQLPLUS commands and 'ampersands' (to accept user input).
Venkat
>
> and stand back and watch it go.
> --
> Chris Kasten
> icq# 7603936
> http://www.kastenracing.com/chris/
>
Sent via Deja.com
http://www.deja.com/
Received on Sun Jan 21 2001 - 20:54:00 CST