Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Easy SQL question
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