Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL statements in command line
Alternatively, you can just put an EXIT command at the end of your
SQL*Plus scripts. This command will terminate SQL*Plus and return
control to the calling process. The EXIT command should work unchanged
across all platforms.
Martin Haltmayer wrote:
>
> Hi Oliver,
>
> If you do not want to change all your script, you can use
>
> sqlplus bla/fasel @script par1 par2 </dev/null
>
> On NT you do not have dev. So create in your current drive a directory
> \dev with one empty file (or a file that just contains one empty line)
> named "null". Be careful: notepad will append ".txt", so use "notepad
> \dev\null." or rename the file after creating. Then you can do similar
> in NT by
>
> sqlplus bla/fasel @script par1 par2 <\dev\null
>
> Martin
>
> Oliver Schoenwaelder wrote:
> >
> > Hi,
> >
> > is there any chance to execute sql statements or pl/sql programs from
> > the command line on a linux machine? If I pass the sql statement as file
> > to sqlplus it is executed but sqlplus doesn't return to the prompt. Are
> > there any additional programs / third party products which provide this?
> >
> > Thanks a lot,
> >
> > Oliver Schoenwaelder
> > Infogrames Deutschland GmbH
Received on Fri Dec 17 1999 - 12:54:02 CST
![]() |
![]() |