Re: [Fwd: SQL Plus Command Line Parameters in 7.3.3.2]

Mike van Thiel <mvthiel_at_knowledgecenters.org> wrote:

>Second Posting : First one had wrong email address, sorry !
>
>Does anyone know the SqlPlus command line parameters.
>
>I'm trying to do something like this
>
>sqlplus userid=john password=doe inputfile=runthissql.sql
>
>i.e. Trying to exeute sql from a command line without actually going
>into sqlplus.

 Try this:

        sqlplus -s john/doe_at_instancename < runthis.sql

 You may want to include an EXIT as the last statement in the SQL file but it shouldn't be necessary.

 The '-s' parameter runs SQLPLUS in silent mode; you don't get all the version information that shows up when you log in normally. Received on Thu Jan 15 1998 - 00:00:00 CET