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: auto-exit pl/sql script from command line?

Re: auto-exit pl/sql script from command line?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 28 Jan 2004 20:34:58 +0100
Message-ID: <tm3g10lsoppv18mucvhmvpe45tkb1cn6tk@4ax.com>


On Tue, 27 Jan 2004 13:20:54 GMT, "Anurag Varma" <avdbi_at_hotmail.com> wrote:

...
>print "
>connect user/pass
>@script.sql
>exit;
>" | sqlplus
>

...

Or a here-document, with the same effect:

sqlplus << EOF
user/pass
start script.sql
exit
EOF (make sure EOF are the only 3 characters on the line, no leading or trailing spaces)

Jaap. Received on Wed Jan 28 2004 - 13:34:58 CST

Original text of this message

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