RE: Database Name ???

From: <mleith_at_bradmark.co.uk>
Date: Mon, 12 Jun 2000 14:00:37 +0100
Message-Id: <10526.108629@fatcity.com>

select instance_name from v$instance;

HTH Mark

-----Original Message-----

From:	MIME :drichard_at_mtlindia=2Ecom=20=
Sent:	12 June 2000 13:45
To:	ORACLE-L_at_fatcity=2Ecom
Subject:	Database Name ???

Dear Experts,

I have three databases in Oracle workgroup server 7=2E3=2E In the front-end application, I want to display the database name to which the connection is available=2E
what query will give this ?

Richard

• Author: INET: drichard_at_mtlindia=2Ecom

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=2Ecom (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)=2E You may also send the HELP command for other information (like subscribing)=2E

 << File: ENVELOPE=2ETXT >>=20= Received on Mon Jun 12 2000 - 08:00:37 CDT