Re: Running PL\SQL script from command line

In article <tciDD2DMH.n14_at_netcom.com>,

   tci_at_netcom.com (Jack Tolson) wrote:
>I am new to Oracle, and I am using SQLPLUS. Is there anyway to
 execute a *.sql script from
>the command line. Something like
>
>sqlplus -p filename.sql?
>
>Help please. Oracle must have something like this???????
>

Yes, you almost had it right.

sqlplus -s _at_filename

With or without the -s, it stands for silent so it won't echo everything. Of course you need user/password either in your script on on the command line before the _at_filename.

Regards,				|
John Carlson                            | Standard Disclaimer Applies.
jecarlso_at_rdyne.rockwell.com             | Other opinions may vary.
Rocketdyne Division, Rockwell Intnl.	|
Canoga Park, CA, USA			|