Didn't know this one ! Diem non perdidi.
But it seems to be the same as select global_name from global_name (on the database on
which I have tried, both are suffixed with a .WORLD); for what I remember from my
numerous databases cloning, the global name is something which is distinct from the
db_name parameter - you can have two different names and you must explicitly set the
two to be the same thing (forgetting about the domain name).
SYS_CONTEXT('USERENV', 'DB_NAME') doesn't show any .WORLD in it and shows the same as
select name from v$database and select value from v$parameter where name = 'db_name'.
<RANT>I have always found all this extremely confusing, indeed. A database name and an
instance name have always been enough for me - and I have always set the two to be the
same thing as long as there was no OPS or RAC involved. I don't see the point in
having so many names that 99.9% of people want to be the same thing.</RANT>
>----- ------- Original Message ------- -----
>From: "GovindanK" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Wed, 10 Sep 2003 17:59:35
>
>How about SELECT ORA_DATABASE_NAME FROM DUAL;
>
>HTH
>GovindanK
>
>> select sys_context('USERENV','DB_NAME') from
><anytable>;
>>
>> At 10:49 AM 9/10/2003 -0800, you wrote:
>>>hi.
>>>
>>>I think there was a dbms package to get some of
>>>the environment variables for a session, but I
>can't
>>>remember anyhting specific. If someone know what
>I'm
>>>talking about and has any details, please Email
>me or
>>>post here
>>>
>>>thanks
>>>
>>>Gene
>>
>> Wolfgang Breitling
>> Oracle7, 8, 8i, 9i OCP DBA
>> Centrex Consulting Corporation
>> http://www.centrexcc.com
>>
>>
>>
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>--
>Author: GovindanK
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and
>web hosting services
>To REMOVE yourself from this mailing list, send an
>E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of
>'ListGuru') and in
>the message BODY, include a line containing: UNSUB
>ORACLE-L
>(or the name of mailing list you want to be removed
>from). You may
>also send the HELP command for other information
>(like subscribing).
>---------------------------------------------------
>------------------
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
