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
where table1.c1|| '-' || table1.c2|| '-' || table1.c3,....,table2.c1|| '-' || table2.c2,...
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 ???