Thanks a lot.
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:v3ii9.35861$g9.102559_at_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 - 10:37:14 CDT
