Re: how to retrieve a particular table?

From: <villagefox_at_my-deja.com>
Date: Mon, 16 Oct 2000 16:44:02 GMT
Message-ID: <8sfb8g$ma7$1_at_nnrp1.deja.com>


Don't know if this answers your question:

select table_name
from user_tab_columns
where column_name = 'GE_CODICE';

In article <8seq9a$8rm$1_at_fe1.cs.interbusiness.it>,   "Maru" <marucanc_at_tin.it> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 18:44:02 CEST

Original text of this message