Re: Table names
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