Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Login to SQLPlus via environment vars?

Re: Login to SQLPlus via environment vars?

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Tue, 16 Mar 1999 09:02:23 +0000
Message-ID: <36EE1E1E.40A0B781@capgemini.co.uk>


The best way I've found to do this is to connect to sqlplus with the /NOLOG option (i.e. Don't logon) and the execute a file to do the connection.

e.g.

SQLPLUS /NOLOG
>@connection_string.sql

Hope this helps....

cn_at_127.0.0.1 wrote:

> Is it possible to make SQL*Plus "automatically" login via setting the
> username and password in an environment variable? I am putting together
> some scripts and would like to store this information in a single place.
>
> -- --
> Craig Nelson - cn_at_clark.net
> http://www.clark.net/pub/cn
Received on Tue Mar 16 1999 - 03:02:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US