Select to return all tables
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