How do I list all existing databases and tables ?
From: Kuo-Chien Kai <kckai_at_cc.nthu.edu.tw>
Date: 1996/05/03
Message-ID: <4mcr09$rbm_at_eusapia.nthu.edu.tw>#1/1
Date: 1996/05/03
Message-ID: <4mcr09$rbm_at_eusapia.nthu.edu.tw>#1/1
For Sybase,
'select name from sysobjects where type='U''
What are the equivalent commands for Oracle ?
'select name from master..sysdatabases'
will list all existing databases.
will list all existing user tables.
---
Best Regards,
Kuo-Chien Kai
----------------------------------------------------------------
Computer & Communication Center | E-mail: kckai_at_cc.nthu.edu.tw
National Tsing Hua University | Phone: +886-35-715131-5160
Hsinchu, Taiwan 30043 | Fax: +886-35-710776
Received on Fri May 03 1996 - 00:00:00 CEST