From: steveee_ca@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: which database i am using?
Date: Tue, 12 Dec 2000 14:37:21 GMT
Organization: Deja.com - Before you buy.
Lines: 28
Message-ID: <915d71$dq9$1@nnrp1.deja.com>
References: <915ck8$d9o$1@nnrp1.deja.com>
NNTP-Posting-Host: 209.226.121.110
X-Article-Creation-Date: Tue Dec 12 14:37:21 2000 GMT
X-Http-User-Agent: Mozilla/4.73 [en]C-SYMPA (Win98; U)
X-Http-Proxy: 1.0 x66.deja.com:80 (Squid/1.1.22) for client 209.226.121.110
X-MyDeja-Info: XMYDJUIDsteveee_ca


If you 've been granted access you can use:

SELECT NAME FROM V$DATABASE;

Hope this helps,

Steve



In article <915ck8$d9o$1@nnrp1.deja.com>,
  senthil <rsenthilkumar@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.