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).
