Re: sqlplus -s option

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 18 Jun 2002 10:08:31 -0500
Message-ID: <u1yb4y6ay.fsf@grossprofit.com>

On Tue, 18 Jun 2002, joephilip2002_at_comcast.net wrote:
> I saw something like in one of the scripts
>

>$ORACLE_HOME/bin/sqlplus -s id/pwd<<EOF

> @file.sql
> EOF
>
> What does this -s option stand for?

I believe this is what you are looking for.

BASH>sqlplus --help
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]

where <option> ::= - | -? | [ [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
      <start>  ::= @<filename>[.<ext>] [<parameter> ...]
	"-" displays the usage syntax
	"-?" displays the SQL*Plus version banner
	"-M <o>" uses HTML markup options <o>
	"-R <n>" uses restricted mode <n>
	"-S" uses silent mode

But here is a complete help file.
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a82950/toc.htm

-- 
Galen Boyer

Received on Tue Jun 18 2002 - 10:08:31 CDT