Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Easy SQL question

Re: Easy SQL question

From: Jackie Marino <Jackie.A.Marino_at_wgp.twc.com>
Date: Thu, 28 May 1998 21:12:43 GMT
Message-ID: <356DD4DA.75FB@wgp.twc.com>


Dave Best wrote:
>
> Pierre wrote:
> >
> > select global_name from global_name;
> >
> > Ciao
>
> or select name from v$database;
>
> L8r..
>
> Dave

select * from v$thread;

This gives you the instance name, too. Received on Thu May 28 1998 - 16:12:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US