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!

Dynamic Search in one table

517373Jun 8 2006 — edited Jun 9 2006
Hi,

I have one table named tab1 consists of multiple columns (col1,........coln). I want to searching one keyword from the whole table. For example keyword is '29' it should be in a street name or some other column. If i given keyword as '29', this should be search my whole table columns and retrieve the exact record..

How to do this????

Pls suggest me and give me the example also...


Regards
Moorthy.GS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2006
Added on Jun 8 2006
15 comments
573 views