Re: Getting current instance name with a select ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 19 Sep 2002 21:07:42 +1000
Message-ID: <v3ii9.35861$g9.102559@newsfeeds.bigpond.com>

Hi Christian,

No, by definition, v$instance can only contain details of the "current" instance.

Cheers

Richard
"Christian BIERO" <cbiero_at_gold-solutions.com> wrote in message news:amca31$i17$1_at_news2.isdnet.net...
>
> Hello,
>
> Is there a way to get the currently connected instance, using a select ?
>
> Something like : SELECT USER FROM DUAL;
>
> V_$ACTIVE_INSTANCES is empty.
> There's the table V$INSTANCE. I got the good information in INSTANCE_NAME
> but could this table have several records ?
>
> Any help would be appreciated.
>
> Thanks
>
> Christian
>
>
>
>
>
Received on Thu Sep 19 2002 - 06:07:42 CDT