Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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... Received on Mon Feb 26 2001 - 10:59:10 CST