Re: Referencing Unix vars with SqlPlus

djensen_at_nyx10.cs.du.edu (Dave Jensen) wrote:

>Does anybody know of a way to reference Unix variables from within SqlPlus?
>I'd like to do this without having to pass them as parameters to the script.
>For example...
>Sqlplus /
> select '$unixvar' from dual;
 

>I know that the above syntax does not work, but is it possible? HOW???
 

>Dave Jensen
>Jensen Consulting
>djensen_at_ares.csd.net
 

>><> Sheltie Fan and Oracle Database Consultant <><

I assume you use Ksh:

sqlplus ${USERNAME}/${PASSWORD} <<! > output.lst

SELECT '${PWD}'
FROM dual
/
! Received on Fri Jul 26 1996 - 00:00:00 CEST