Oracle Text (MOSC)

MOSC Banner

CATSEARCH - wildcard % does not work for catsearch

edited Feb 10, 2014 12:00PM in Oracle Text (MOSC) 1 commentAnswered
Hi,

I am trying to use wildcard % in catsearch, it does not work.
However according to document http://g-solutions.net/icreate-content/main/oracle_wildcard_searching.aspx, wildcard % can be used in 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