Re: HELP:How to get list of tables in a database in Oracle?

From: Kim Ng <kimmng_at_uswnvg.com>
Date: 15 Jul 94 20:06:56 GMT
Message-ID: <32784_at_uswnvg.uswnvg.com>

Try:

select table_name from all_tables;

It should list all the tables you have access to regardless of who the owner is.
"descr all_tables" if you want to get other info.

---

 Kim Ng
 (Just a low life contract programmer. Thus, my clients won't adopt my views.) Received on Fri Jul 15 1994 - 22:06:56 CEST