Avatar of CMANI10
Flag for India asked on


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 ???

Oracle Database

Avatar of undefined
Last Comment

8/22/2022 - Mon
Ivo Stoykov

it it takes too much time there might be two main reasons (and some minors too)
either the query is badly written or
table(s) are huge.

Also depends on OS and oracle versions.

Without the query source no one could help.

As for oracle text - here you'll find lots of info - papers, technicals, articles, documentation.


Ivo Stoykov

Leave the query source and query tuning.
Is there any other way to implement this without using concordination of table columns and using " like" opperator.
Ivo Stoykov

if you mean where clause - yes - dynamic query.

Function that return composed where clause and the result piped to execute immediate


Ivo Stoykov
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question