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: Happl Oberlin <happl_at_mail.com>
Date: Tue, 20 Feb 2001 15:59:56 +0100
Message-ID: <happl-7034D6.15595620022001@news.fu-berlin.de>

In article <3a928153.713508531_at_news.sarenet.es>,  suppot@_DO_NOT_SPAM_bilbao.com (Support) wrote:

>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?

select table_name
from user_tab_columns
where column_name = 'FIELD';

Instead of FIELD type the name of your field.

Greetings from Switzerland -- Gruesse aus der Schweiz Happl Received on Tue Feb 20 2001 - 08:59:56 CST

Original text of this message

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