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_tables
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:58:39 CST
![]() |
![]() |