Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Searching a field
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