Re: With SQLPLUS, how to get an environment variable ?
From: Andrew Rose <sydscan_at_ozemail.com.au>
Date: 1996/10/24
Message-ID: <54ook3$dkt_at_reader1.reader.news.ozemail.net>#1/1
Date: 1996/10/24
Message-ID: <54ook3$dkt_at_reader1.reader.news.ozemail.net>#1/1
Jean-Marc LHABITANT <lhabitan_at_belfort.cnet.fr> wrote:
>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
export MYENVAR='My UNIX environment variable'
echo select <fields> from <table> where <field>=$MYENVAR > temp.sql sqlplus -s un/pw _at_temp.sql
HTH Andrew Received on Thu Oct 24 1996 - 00:00:00 CEST