Re: Searching a field
From: Stephan Langer <slanger_at_dixi-wc.de>
Date: Wed, 28 Feb 2001 08:03:42 +0100
Message-ID: <3A9CA2CE.7697A520_at_dixi-wc.de>
Date: Wed, 28 Feb 2001 08:03:42 +0100
Message-ID: <3A9CA2CE.7697A520_at_dixi-wc.de>
Hi,
user_tab_columns takes Column and Table-Names in UPPERCASE. May be that's why you don't find the column?
hth Stephan
Support schrieb:
> Hi!
>
> Firstly, thanks to everybody who answered last post.
>
> I was looking for a script to find a table.
>
> I've got the name of a field. I know it exists, but I do not know in
> wich table it is.
>
> I tried with:
> SELECT table_name FROM user_tab_columns WHERE column_name='XXX'
> but I got 'no rows selected'.
>
> In fact, if I with
> SELECT column_name FROM user_tab_columns WHERE table_name='YYYY'
> I got the same message.
>
> Any help? Thank you in advance...
>
> ==========
> MIRELLO
Received on Wed Feb 28 2001 - 08:03:42 CET