full text search in oracle (merged 2) [message #547632] |
Thu, 15 March 2012 04:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d8d54604424af68f3c669fe2bc54c02?s=64&d=mm&r=g) |
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
hello friends,
i have a problem in full text searching in my database.
please guide me how should i find the all correspondind records.
and scenario is like--
suppose i have a table called "msg" and it has one field named "text" and it has vaules-------
this is the test;
test successfull;
test completed
test pending
pending
hello
hi
no pending
test pending
then when i give any string in search condition then i fetch all records in which a the any part of search string exist.
like-- i give 'test pending' then it fetch all records which has either 'test' or 'pending' or both.
thanx in advance.
|
|
|
|
|