This content has been marked as final. Show 4 replies
Q1: Non-alphanumeric characters are "break" characters by default and are stripped out of both indexed text and query terms.
Q2: Oracle Text uses the normal Oracle wild cards - % for multiple characters and _ for single characters.
Beware that using leading wild-cards (eg %EISURE) will be very slow unless you have the SUBSTRING_INDEX or PREFIX_INDEX options selected, as it prevents the use of an index when looking up words in the main text index.
catsearch(text, '*EISURE', '') returns "no rows" because wildcard left truncation not supported.
As documented in Text Reference Guide Table 1-2 CATSEARCH Query Operators
Oops, missed the fact that it was CATSEARCH not CONTAINS. Thanks, Edwin.