Re: SQL statements in command line

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 10 1999 - 11:50:41 CST