Re: query $ORACLE

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Nov 2004 03:14:53 -0800
Message-ID: <92eeeff0.0411170314.15ad53e7@posting.google.com>

karistom_at_hotmail.com (Christine) wrote in message news:<693b7163.0411161744.56f9769d_at_posting.google.com>...
> johnleslie_at_madasafish.com (John Leslie) wrote in message news:<4412dd31.0411160801.3b68f4d8_at_posting.google.com>...
> > Is there a table or view that contains the value for the current $ORACLE_HOME?
> >
> > JL
>
>
> in OS command line, put "set" command.
> $ set
>
> It will show you all environment values
> including $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID ...

FYI... the OP wants to know if this value is listed in some table/view IN the database.

Regards
/Rauf Received on Wed Nov 17 2004 - 05:14:53 CST

Re: query $ORACLE_HOME