Skip to Content
Former Member
Mar 27, 2015 at 06:15 AM

Contains predicate for search on VARCHAR column


Hi Team,

We have a requirement as mentioned below:

One table A with 80 million data and 200 columns in the table.One more table K which contains 100 values and 1 column which stores key words.

I need to find all data from table A with a lookup from table K. Within contains predicate I could understand we need to pass <string contant> as second parameter but instead of that I need to pass a table with multiple values as search input.

select ....

from A

where contains ( A.col10 , <table B>);

Your help is appreciated.