Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select to return all tables

davidthi808-JavaNetSep 23 2007 — edited Sep 25 2007
Hi;

If I want the tables I own, I can use:
SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME

And if I want all tables in the database I can use:
SELECT TABLE_NAME FROM ALL_TABLES ORDER BY TABLE_NAME

But is there a way to get all non system tables (same question for views, and columns if there are system columns) in the database? I don't care who owns the tables & views, I want to show the user all tables they might find of interest. So it's any tables that are not created by the system.

For example, the HR database has 1 user view (for the user HR) but over 1,000 total views and I think the rest are all system views. And for tables it jumps from 7 to 62.

??? - thanks - dave
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2007
Added on Sep 23 2007
22 comments
4,462 views