Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> help with a global query
Hi,
Is it possible to search for an item in all the tables of the database at once?
e.g. I want to see all the occurences of '#' in all the columns in all the tables in the database. Is ther a way to write this w/o having to hardcode each table and column in the DB?
thanks
adam
Received on Sun Aug 23 1998 - 06:47:14 CDT
![]() |
![]() |