With SQLPLUS, how to get an environment variable ?
From: Jean-Marc LHABITANT <lhabitan_at_belfort.cnet.fr>
Date: 1996/10/22
Message-ID: <lbphgnn9h3q.fsf_at_tholos.belfort.cnet.fr>#1/1
Date: 1996/10/22
Message-ID: <lbphgnn9h3q.fsf_at_tholos.belfort.cnet.fr>#1/1
I wonder how, within SQLPLUS, to get an UNIX environment
variable such as $HOME ?
For example :
export MYENVAR='My UNIX environment variable'
sqlplus
....
SQL> select <fields> from <table> where <field>=$MYENVAR
If you know how to do this, please tell me !
thanks
Jean-Marc Received on Tue Oct 22 1996 - 00:00:00 CEST