Re: Option to add EXIT to end of SQL script

In article <Cq27py.GD7_at_netnews.whoi.edu>

           dhiltz_at_whsun1.wh.whoi.edu "David Hiltz" writes:
>
> If have a few SQL scripts that I would like to run with and without EXITs at
> the end. Sometimes
> I want to run the scripts from the Unix prompt and return to the Unix prompt
> when done (use an EXIT)
> and other times I want to run a script from the Unix prompt and then be left
> in SQL*Plus to perform other
> operations.
>
> I can do it by creating a temporary file, but was wondering if there was a
> more elegant method.
>

script.sql has no exit command at the end

to run a script and return to unix:

        sqlplus user/pass <script.sql

to run the same script and remain in SQL*Plus:

        sqlplus user/pass _at_script.sql

cheers,

-- 
Simon Bonnick   simon_at_nuts.demon.co.uk   +44 860 852845   simon_at_trimcase.com