Re: Getting the name of the database

From: <poohland_at_my-dejanews.com>
Date: Wed, 22 Jul 1998 22:41:35 GMT
Message-ID: <6p5pr0$rau$1@nnrp1.dejanews.com>

another way:

select name, value from v$parameter
where name in ('db_name','db_domain');

In article <35B4CB47.609F0A64_at_bmgdirect.com>, molin_at_bmgdirect.com wrote:
>
>
> calberto_at_my-dejanews.com wrote:
>
> > Hi all!
> >
> > Is there any function in Oracle that returns the name of the database I am
> > using like there is SELECT USER FROM DUAL to get the username?
> >
> > Thanks in advanced,
> >
> > Carlos
>
> Try SELECT * FROM GLOBAL_NAME
>
> -Michael
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 17:41:35 CDT