Re: Retrieving table name

From: Imprecise <f_puhan_at_precise.com>
Date: Tue, 18 Jun 2002 08:25:39 -0400
Message-ID: <f_puhan-91A7ED.08253918062002@vienna7.his.com>

In article <3d0f0f72$0$10519$626a54ce_at_news.free.fr>, "Noemie FB" <noemie_freyburger-buttet_at_epsilon_ch> wrote:

> Hello
>
> I would like to retrieve all tables containing a column named "status".
> How can I do that ?
>
> Thanks in Advance
>
> Noemie

SELECT TABLE_NAME
FROM DBA_TAB_COLS
WHERE UPPER(COLUMN_NAME) = 'STATUS'
/

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!

Received on Tue Jun 18 2002 - 07:25:39 CDT