Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL statements in command line

Re: SQL statements in command line

From: Scott Kronheim <skronheim_at_synertechsystems.com>
Date: Fri, 17 Dec 1999 13:54:02 -0500
Message-ID: <385A86CA.D3783D6F@synertechsystems.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US