Re: query $ORACLE_HOME

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 19 Nov 2004 16:59:17 -0800
Message-ID: <1100912271.386506@yasure>

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.

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Fri Nov 19 2004 - 18:59:17 CST