Re: query oracle_home in sqlplus
From: <tunity5_at_yahoo.com>
Date: 18 Sep 2003 15:19:23 -0700
Message-ID: <32bcd267.0309181419.689c72_at_posting.google.com>
Date: 18 Sep 2003 15:19:23 -0700
Message-ID: <32bcd267.0309181419.689c72_at_posting.google.com>
peterlin <member35081_at_dbforums.com> wrote in message news:<3384724.1063874631_at_dbforums.com>...
> hi,
>
> How can I query the $ORACLE_HOME in sqlplus ?
>
> Thanks!
>
> peter
This should give you what you want:
select global_name from global_name; Received on Fri Sep 19 2003 - 00:19:23 CEST