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: which database i am using?

Re: which database i am using?

From: <steveee_ca_at_my-deja.com>
Date: Tue, 12 Dec 2000 14:37:21 GMT
Message-ID: <915d71$dq9$1@nnrp1.deja.com>

If you 've been granted access you can use:

SELECT NAME FROM V$DATABASE; Hope this helps,

Steve

In article <915ck8$d9o$1_at_nnrp1.deja.com>,   senthil <rsenthilkumar_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 12 2000 - 08:37:21 CST

Original text of this message

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