Re: how to retrieve a particular table?

From: Eric Givler <egivler_at_flash.net>
Date: Sat, 21 Oct 2000 00:37:02 GMT
Message-ID: <Oy5I5.5523$NP.367692_at_news.flash.net>


select table_name , column_name
from dba_tab_columns
where column_name = 'GE_CODICE';

"Maru" <marucanc_at_tin.it> wrote in message news:8seq9a$8rm$1_at_fe1.cs.interbusiness.it...
> Hi everyone!
> Please
> could you tell me how to do the next thing:
> I have an oracle database. I have a table called "CODICI" and a field of
> CODICI called "GE_CODICE".
> I need to retrieve all names of related tables to CODICI which contain a
> field called exactly like that, "GE_CODICE" .
> Which SQL?
>
> Thank you.
> Maru
>
>
Received on Sat Oct 21 2000 - 02:37:02 CEST

Original text of this message