|
try
select * from tab;
is this what u were searching for??
anoop
----- Original Message -----
Sent: Tuesday, September 25, 2001 6:11
PM
Subject: Re: )FF-TOPIC:searching for all
databases in a DBMS in the server
Hi,
It is possible but
this is database specific.
Ex. In Oracle, run the following SQL command
(after connecting as user "SYSTEM"
to the db with the appropriate
passowrd)
select username from dba_users;
The resultset will
contain a list of all the users (I guess this is what you are
after).
The catch is that the SYSTEM is a DBA user and this user is generally
not
advised to login the system for application specific tasks, but surely
this
can be worked around by your DBA. Maybe you can speak to
him! :-)
Regards
Nitin Goyal
Webrizon eSolutions Pvt. Ltd.,
INDIA
[EMAIL PROTECTED]
There
is no failure except in no longer trying.
----- Original Message
-----
From: "Soubhratra Das" <[EMAIL PROTECTED]>
To:
<[EMAIL PROTECTED]>
Sent:
Tuesday, September 25, 2001 4:19 PM
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 SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV
Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To
unsubscribe, send email to [EMAIL PROTECTED] and include in
the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV
Help: http://www.lsoft.com/manuals/user/user.html
|
