Re: Searching a field

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