Re: Searching a field
From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Mon, 26 Feb 2001 18:16:10 -0000
Message-ID: <t9l769chfs11fd_at_xo.supernews.co.uk>
Date: Mon, 26 Feb 2001 18:16:10 -0000
Message-ID: <t9l769chfs11fd_at_xo.supernews.co.uk>
"Support" <support_at_PLEASE_DO_NOT_SPAM_bilbao.com> wrote in message
news:3a9a8b92.1240419398_at_news.sarenet.es...
> 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.
>
Firstly check that the user you are connected to when issuing the above sql is the user that owns the table. This is most likely your problem? Received on Mon Feb 26 2001 - 19:16:10 CET