Re: Searching a field

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 20 Feb 2001 21:56:19 +0100
Message-ID: <sdm59t03m2p4nvf1h8d5bjbgm0atc42jr0@4ax.com>

On Tue, 20 Feb 2001 14:38:20 GMT, suppot@_DO_NOT_SPAM_bilbao.com (Support) wrote:

>Hi!
>
>I've got the name of a field. I know it exists, but I do not know in
>wich table it is.
>
>Is there any good script to find it?
>
>Best regards...
>
>============
>MIRELLO

Just use

select table_name, owner
from dba_tab_columns
where column_name = '<your column>'

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Feb 20 2001 - 14:56:19 CST