Re: Is there a way to find known field of unknow table ????????/

From: <jtesta_at_my-dejanews.com>
Date: Wed, 23 Sep 1998 12:41:24 GMT
Message-ID: <6uaq9k$al9$1@nnrp1.dejanews.com>

How about select owner, table_name from sys.dba_tab_columns where column_name = "THE COLUMN YOU ARE LOOKING FOR"; or am i missing something here?

hth, joe
http://www.oracle-dba.com

In article <3607EE61.235A830C_at_k.com>,
k <k_at_k.com> wrote:
> Hi,
>
> Is there a way to find a particular field from unknow table, i mean,
> i know the field name but i don't know which table it belongs to.
>
> am in unix environment with oracle 7.3 installed. I can login as
> SYSDBA. I appericate your help and time. Thanks
>
> Kedda.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 23 1998 - 07:41:24 CDT