Re: Oracle tables with field name
From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Wed, 23 Jul 2003 16:15:37 +0100
Message-ID: <bfm8th$1hfl$1_at_news.icl.se>
Date: Wed, 23 Jul 2003 16:15:37 +0100
Message-ID: <bfm8th$1hfl$1_at_news.icl.se>
from memory
SELECT owner, table_name
FROM ALL_TAB_COLUMNS
WHERE column_name = 'EMP_CODE'
"Michel R." <michelr_at_hydro.qc.ca> wrote in message
news:mAxTa.213$Rl3.9359_at_wagner.videotron.net...
> Hello all,
>
> How can I select all tables which have a field named, say "EMP_CODE"?
>
> This shouldn't be too difficult.
>
> Thank to all.
>
>
Received on Wed Jul 23 2003 - 17:15:37 CEST