Correct me if I am wrong, but these shouldn't these only be different in a
parallel server environment?
> -----Original Message-----
> From: Winnie_Liu_at_infonet.com [SMTP:Winnie_Liu_at_infonet.com]
> Sent: Monday, June 12, 2000 1:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Database Name ???
>
> That will give the instance name. But v$database will give the database
> name.
>
> (SID not necessary equal to DB_NAME)
>
> Winnie
>
>
>
>
>
> mleith_at_bradmark.co.uk on 06/12/2000 07:18:19 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
> select instance_name from v$instance;
>
> HTH
>
> Mark
>
> -----Original Message-----
> To: ORACLE-L_at_fatcity.com
>
>
>
> 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).
>
> << File: ENVELOPE.TXT >> --
> Author:
> INET: mleith_at_bradmark.co.uk
>
> 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).
>
>
>
>
>
>
> --
> Author:
> INET: Winnie_Liu_at_infonet.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
Received on Tue Jun 13 2000 - 09:22:18 CDT
