Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to know to what table a field belongs?

Re: How to know to what table a field belongs?

From: Jørn Hansen <jorn-asko_at_sstofasnets.dk>
Date: Tue, 19 Oct 2004 23:12:53 +0200
Message-ID: <41758342$0$23076$ba624c82@nntp05.dk.telia.net>


select table_name from user_tab_columns
where column_name = 'PROJ_ID';

md9_at_ibest.com.br wrote:
> Hi,
>
> I´m fixing a system made by another programmer,this system is very
> large and have no documentation at all.
>
> I want a command like this:
>
> select TABLE_NAME from USER_TABLES WHERE FIELD_NAME='PROJ_ID'
>
> Regards,
> Marcello Dias
Received on Tue Oct 19 2004 - 16:12:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US