Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Phrase Serach with special charaters in between

876250Dec 5 2011 — edited Dec 8 2011

Gurus,

We were trying to implement a search functionality in which if we give two seperate words
Mark Antony by default behaviour it will do phrase serach so only occurunces of these two words together will be returned.

With blank space we also wanted to consider special characters in between these words like /,\,|,-,_,+

so that the resultant records for querrying following phrases all should return the same results.

Mark Antony
Mark/Antony
Mark\Antony
Mark|Antony
Mark-Antony
Mark_Antony
Mark+Antony

I tried using ndata section but it is not helping, I tried using skipjoin in lexer parameter even that is not helping.
Please give me a solution to achieve this functionality.

Thanks & Regards,
Vikas Krishna

This post has been answered by Herald ten Dam on Dec 6 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2012

Added on Dec 5 2011

#database-key-features, #text

6 comments

501 views