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

Dear k,

Try:

SELECT TABLE_NAME
FROM USER_TABLES
WHERE COLUMN_NAME = 'YOUR_FIELD_NAME'
/

which will list all tables and views containing a column with the name you have.

Good Luck,

Paul.

k <k_at_k.com> wrote in article <3607EE61.235A830C_at_k.com>...
> 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.
>
>
>
Received on Tue Sep 22 1998 - 15:36:30 CDT