Re: With SQLPLUS, how to get an environment variable ?

Hi, Jean-Marc,

You can just put the $MYENVAR at UNIX command line like:

      $ sqlplus username/password _at_sql_script $MYENVAR

And in the sql_script.sql:

       select <fields> from <table> where <field>= '&1'

Since the variable &1 is $MYENVAR, your select statement will get your UNIX environment variable. Hope it will help you.

Aiwen Received on Fri Oct 25 1996 - 00:00:00 CEST