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

Hi k,

try
SELECT U1.TABLE_NAME , U1.COLUMN_NAME
FROM SYS.USER_OBJECTS U, SYS.USER_TAB_COLUMNS U1 WHERE U.OBJECT_NAME = U1.TABLE_NAME
AND OBJECT_TYPE = 'TABLE'
AND U1.COLUMN_NAME LIKE ... regards Jan Dieckmann
Jan.Dieckmann_at_keeptool.com

k 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.
Received on Wed Sep 23 1998 - 12:23:57 CDT