Re: sqlplus command line

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 09 Apr 1999 04:26:37 GMT
Message-ID: <37105652.3513419@netnews.worldnet.att.net>

On 8 Apr 1999 18:03:13 GMT, "RABK" <rkarl_at_consultec-inc.com> wrote:

>How do I execute a script.sql file from the command line????

Use the @ or START commands. If your script file is the_script.sql, you could issue either of the following commands to execute it:

SQL>@the_script.sql
SQL>START the_script.sql

If you mean from the UNIX (or NT) command-line, do something like this:

sqlplus system/manager_at_service @the_script.sql

On Unix you should probably create an ops$ account rather than place the password on the command-line. regards,

Jonathan Received on Thu Apr 08 1999 - 23:26:37 CDT