Re: Retrieving table name

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Tue, 18 Jun 2002 09:26:52 -0600
Message-ID: <3D0F513C.16AC050@noaa.gov>

It's easy. Check out dba_tab_columns, all_tab_columns, and user_tab_columns,
and then execute a query like this:

select table_name from xxx_tab_columns where column_name = 'STATUS' [and owner = 'XXX'];

Be sure to express the owner name (if necessary, that is) and the column name in uppercase because that's the way the data dictionary stores this information.

Bye,
TG

Noemie FB wrote:

> Hello
>
> I would like to retrieve all tables containing a column named "status".
> How can I do that ?
>
> Thanks in Advance
>
> Noemie
Received on Tue Jun 18 2002 - 10:26:52 CDT