Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> searching entire database
How do I search the entire database for a value and return the
tablenames and column names that contain this value? For argument
sake, let's say I'm searching for the text "the quick brown fox".
I think someone posted this question before but it never got any responses--since it's been awhile, i thought i might post it again.
In case your wondering why I want to do this, I'm using a software package that stores all it's data in a database. It shows me the data, but I have no idea what tables and column names contain these values so it's hard to change the data through sql scripting.
thanks a lot,
Sean.
Received on Sat Feb 10 2007 - 02:40:16 CST