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

From: <jtesta_at_my-dejanews.com>
Date: Wed, 23 Sep 1998 12:43:56 GMT
Message-ID: <6uaqec$amg$1@nnrp1.dejanews.com>

FYI, user_tables does NOT have column_name as an attribute.

So your query wont work, change user_tables to user_tab_columns

In article <01bde668$b559f240$073ff161_at_pko.ntdom1>, "Paul Koppens" <pkoppens_at_dstm.nl> wrote:
> 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.
> >
> >
> >
>

-----== 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:43:56 CDT