Re: which database i am using?

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Wed, 13 Dec 2000 02:08:37 -0600
Message-ID: <3A372E85.AFBF2EA4@ntsource.com>

You could call the function dbms_standard.database_name as

select dbms_standard.database_name from dual;

(This worked on 8.1.6 with a new user having just connect privilege.)

Frank Hubeny

senthil 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.
Received on Wed Dec 13 2000 - 02:08:37 CST