troubleshooting Question

Oracle 10G "ORACLE TEXT SEARCH"

Avatar of CMANI10
CMANI10Flag for India asked on
Oracle Database
5 Comments1 Solution1300 ViewsLast Modified:
My aim to give search option in asp dot net.
Actually Iam having two tables(eg table1 and table2 ) with each contains 20 columns.
I need to search that two tables which contain a particular word.
For that I have used the below qr=uery

select table1.c1,table1.c2,table1.c3,....,table2.c1,table2.c2,...
where table1.c1|| '-' || table1.c2|| '-' || table1.c3,....,table2.c1|| '-' || table2.c2,...
like '%test%'

The above query is working but it takes too time.
I have searched in oracle ,they saying a concept called "ORACLE TEXT SEARCH"
Can you explain how to implement this ???




ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros