Oracle Text (MOSC)

MOSC Banner

CATSEARCH wildcard % does not work

edited Dec 23, 2013 2:00AM in Oracle Text (MOSC) 13 commentsAnswered
Hi,
I tried to use wildcard % in catsearch, however it seems that it does not work.
According to document http://g-solutions.net/icreate-content/main/oracle_wildcard_searching.aspx, wild card % is allowed CATSEARCH.

********************************************************************************************
SELECT id, price, name
FROM   my_items
WHERE  CATSEARCH(description, '%ouse%', null)> 0;

no rows selected

**********************************************
**********************************************
SELECT id, price, name
FROM   my_items
WHERE  CATSEARCH(description, 'House', null)> 0;

      2860        859
House: 859


        ID      PRICE
---------- ----------
NAME
----------------------------------

      2861        860
House: 860

      2862        861
House: 861

      2863        862
House: 862


        ID      PRICE
---------- ----------
NAME
----------------------------------

      2864        863
House: 863


1000 rows selected.
**********************************************
Am I missing any configuration ? Please guide.

Regards,
Eye Gee

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center