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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Searching a field

Re: Searching a field

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Tue, 20 Feb 2001 13:59:48 GMT
Message-ID: <oLuk6.6634$hQ5.44441@skycache.prestige.net>

select table_name
  from all_tab_columns
where column_name = '<field name replaces everything between the single quotes>';

"Support" <suppot@_DO_NOT_SPAM_bilbao.com> wrote in message news:3a928153.713508531_at_news.sarenet.es...
> Hi!
>
> I've got the name of a field. I know it exists, but I do not know in
> wich table it is.
>
> Is there any good script to find it?
>
> Best regards...
>
> ============
> MIRELLO
Received on Tue Feb 20 2001 - 07:59:48 CST

Original text of this message

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