Re: NOVICE - How to get a list of tables in DB

If I understood your question correctly:

SELECT owner, table_name
FROM all_tables
ORDER BY 1,2 gallagher_at_nm-us.campus.mci.net (Mike G) wrote:
>This is a question from a beginning ORACLE user.
>
>I need to find out how to find out how to get a listing of all the owners of
>database tables and all the tables that our organization has.
>
>What this translates to is that I need something for tables that is analagous
>to the DIRECTORY listing of files on a hard drive.
>
>Tables are referenced as owner.table_name e.g., finance.orders or
>gwb.wells. But I can't reference them unless I know what they are!
>Thanks, Mike
Received on Fri Mar 22 1996 - 00:00:00 CET