Re: How to define Unix environment variables in the sql files

To use an environment variable, just use it as you would in a shell script. For example:
@$HOME/sql/myapp.sql

"Huy Vu" <huyv_at_usa.net> writes:

> Hi all,
>
> I tried to define an Unix environment variable in an sql file but not
> successful.
>
> I can put '?' to replace $ORACLE_HOME variable but not others.
>
> Does someone know how to define an Unix environment in the sql files.
>
> Thanks in advance for any help.
>
> DH.
>
>
 

-- 
                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.