Hi Richard,
You would have to either look at the oratab file which lists all databases
on the machine or do a select name from v$database.
HTH,
- drichard_at_mtlindia.com wrote:
>
>
> 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).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
Received on Mon Jun 12 2000 - 08:11:22 CDT
