All, I have an interesting problem for which I need some advice. I need to search an Oracle database for a piece of data...don't have the table name, or the column name...only have the data that needs to be searched (say for example "JOHN SMITH").

So how can I write a sproc, that will loop through each user table, then in each row/column and search for JOHN SMITH? If I am dealing with about 50 tables or so, would it just be better to use the Schema Browser in TOAD and just eye-ball it? Is there a tool available that would let me do some type of global search, for example like the Windows search? Thanks!!