Re: Database Name ???

Select name from v$database.

At 06:36 AM 6/12/00 -0800, you wrote:

>Richard,
>You can get it from:
>
>select substr(global_name,1,instr(global_name,'.')-1) from global_name;
>
>Martyn
>
>
>
> (Embedded
> image moved drichard_at_mtlindia.com
> to file: 12/06/2000 14:15
> pic27720.pcx)
>
>
>
>
>Please respond to ORACLE-L_at_fatcity.com
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc:
>
>
>
>
>
>Dear Experts,
>
>I have three databases in Oracle workgroup server 7.3.
>In the front-end application, I want to display the database name to which
>the connection is available.
>what query will give this ?
>
>Richard
>
>
>--
>Author:
> INET: drichard_at_mtlindia.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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).
>
>
>----------------------------------------------------------------
>The information transmitted is intended only for the person or entity to which
>it is addressed and may contain confidential and/or privileged material. Any
>review, retransmission, dissemination or other use of, or taking of any action
>in reliance upon, this information by persons or entities other than the
>intended recipient is prohibited. If you received this in error, please
>contact the sender and delete the material from any computer.
Received on Mon Jun 12 2000 - 10:32:20 CDT