How to set Environment Variable from sqlplus

[YS]

Hi Everyone,
Can anyone please let me know how to set Environment variable from SQLPLUS .... or

tell me how to suppress Connected. message when using
connect / as sysoper
and also
supress the following messages when supplying value for bind variable
old 1: select to_char
new 1: select to_char


I have tried to set heading off echo off feedback off

...
..
.

[slimdave]

sqlplus -s invokes "silent" mode.

"set verify off" hides the old/new

[gandolf989]

Any sql commends that you put in C:\oracle\ora92\sqlplus\admin\glogin.sql get run everytime you startup sqlplus. So if you want to set any environment variables, then put them here.

[stecal]

Oracle will also look in the starting directory (where you launch SQL*Plus) for login.sql. As mentioned, you can set global login parameters in glogin.sql. When you start SQL*Plus, the environment variables that were in existence when you started stay in existence for that window. You can host out (>! UNIX command or >host UNIX command or simply >host) to do something in your shell window. However, you cannot effect a change with respect to environment variables in your SQL*Plus session.

[marist89]

Originally posted by stecal
Oracle will also look in the starting directory (where you launch SQL*Plus) for login.sql.

If we want to be 100% correct, we'd say "sqlplus looks for login.sql in your $SQLPATH".

[stecal]

Originally posted by marist89
If we want to be 100% correct, we'd say "sqlplus looks for .login in your $SQLPATH".

If login.sql is in the directory where you invoke the command, it will run, and that is without setting the SQLPATH variable. If you want login.sql to run from anywhere, SQLPATH variable, like the PATH variable, will do the trick.

[YS]

Originally posted by slimdave
sqlplus -s invokes "silent" mode.

"set verify off" hides the old/new

Hi thanks for the verify tip ... I was using -s to invoke silent mode, but still get the Connected. message