For all the databases in an SQL*Server:
1> select name from master..sysdatabases ;
For Oracle there is no exact equivalent because there is a 1:1 mapping
between instance and database (i.e. the server only contains one database).
You can look in $ORACLE_HOME/network/admin/tnsnames.ora for a list of known
instances (servers) or look in $ORACLE_HOME/dbs for the init.ora files, but
neither list is necessarily complete - it's up to the DBA and how Oracle is
installed at your site.
Eoin.
-----Original Message-----
From: Soubhratra Das [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 3:49 AM
To: [EMAIL PROTECTED]
Subject: )FF-TOPIC:searching for all databases in a DBMS in the server
Hi all
Is it possible to display the names of all the databases present in a DBMS
in server. Suppose the DBMS is oracle or SQL server.How to find which
databases are present in these databases and show the database names on web
page.
TIA,
soubhratra.
____________________________________________________________________________
___
Soubhratra Das
Master of Computer Applications.
Sun Certified Java Professional.
____________________________________________________________________________
___
Where there is a will there is a way.
____________________________________________________________________________
___
____________________________________________________________
Sent via ocsemail from IASRI Intranet System intranet
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
