Re: which database i am using?

From: Prathamesh Shah <prathamesh_at_worldnet.att.net>
Date: Fri, 15 Dec 2000 03:59:47 GMT
Message-ID: <TGg_5.2632$pi2.190285@bgtnsc07-news.ops.worldnet.att.net>

select * from global_name;

will give you what database instance you are connected to.

"senthil" <rsenthilkumar_at_my-deja.com> wrote in message news:915ck8$d9o$1_at_nnrp1.deja.com...
> hi,
>
> i am an user without dba priveleges and would like to query a
> table/view that gives the database name. anybody knows the table/view
> name???
>
> thanks,
> senthil.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 14 2000 - 21:59:47 CST