Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to search in all rows and all columns?

movilogoMar 26 2009 — edited Mar 28 2009
Suppose I want to search for a word but I don't know in which column it exists.

Is there any function to do search in all columns?

Or it is something I need to write myself by parsing data dictionary and then looping thru all columns in my procedure?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2009
Added on Mar 26 2009
7 comments
4,201 views