Re: Table names

From: Allan Hicks <ahicks_at_acsatlanta.com>
Date: 1996/07/19
Message-ID: <31EF786C.2B75_at_acsatlanta.com>#1/1


Barbara Hiles wrote:
>
> Is there a table to list or a place in documentation that lists all of the
> Oracle tables? System tables and user tables? I know of dba_tables and
> user_tables. I'm looking for a list of the tables like dba_tables, roles, etc.

In appendix B of the Admin Guide, there is an exhaustive list of the Oracle data dictionary. Page B-68 documents a table called user_tables. If you

select table_name from user_tables;

You get all of the users tables. You can also select (from the next page
of the manual)

select column_name from user_tab_columns where table_name='foo';

To get the columns for a table.

There are several other handy tables that you can use here.

I hope this helps

-Allan Hicks Received on Fri Jul 19 1996 - 00:00:00 CEST

Original text of this message