Re: query $ORACLE_HOME

On Fri, 19 Nov 2004 16:59:17 -0800, DA Morgan <damorgan_at_x.washington.edu> wrote:

>Andy Hassall wrote:
>
>> On Thu, 18 Nov 2004 08:12:32 -0800, DA Morgan <damorgan_at_x.washington.edu>
>> wrote:
>>
>>>Does anyone have a list of all of the environment variables that can
>>>be obtained using get_env? If so I would appreciate a copy for the
>>>PSOUG library: Can't find anything on OTN.
>>
>> The simple answer appears to be "all of them". It's just giving you the
>> operating system environment variables for the Oracle process; so the variables
>> depend on what you've got set on the system.
>
>I have no environment variable set on my system name _SQLPLUS_RELEASE or
>_O_VERSION: Neither do you.

 This is true, but a somewhat unexpected statement...

>But I did fine the answer to my question ... at the SQL> prompt just
>type the word DEFINE and <Enter>.
>
>The PSOUG web site library has now been upgraded with this information.

 What question are you answering?

 get_env in dbms_system does not give you SQL*Plus substitution variables. _SQLPLUS_RELEASE and _O_VERSION are examples of substitution variables automatically defined by SQL*Plus, and yes DEFINE would show them, but what's that got do with dbms_system.get_env and environment variables?

 If you're now looking for the predefined SQL*Plus substitution variables, such as _SQLPLUS_RELEASE, they're documented in the SQL*Plus manual:

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b12170/ch13.htm#i2675128

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool