Re: How can I get all the table name?

From: Radu Lascae <r.lascae_at_nospam.wanadoo.nl>
Date: Tue, 22 Aug 2000 21:54:21 +0200
Message-ID: <39a2da61$0$18423@reader3>

For example, using an sql tool

select table_name from all_tables
select index_name from all_indexes
describe theTableName

Alternativelly, use the Oracle schema manager.

Hth,
Radu Lascae
Joseph Ovadia <ovadia_at_att.com> wrote in message news:39A2CE78.5C4D17D9_at_att.com...
> Hello,
>
> I need to get all the table names in the database and also the item in
> the table. (What elements does the table contains and any index).
>
> Thanks for any help.
>
> Joseph
>
Received on Tue Aug 22 2000 - 14:54:21 CDT