Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: auto-exit pl/sql script from command line?
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