DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Text

  1. #1
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304

    Unhappy Oracle Text

    Hi

    I have following values in a column(criteria) in my table.

    comm
    community
    communal
    commerce
    ..
    ..

    I have created CTXCAT index as follows:

    CREATE INDEX IND_SRCH_CRITERIA ON search_attr(criteria) INDEXTYPE IS ctxsys.ctxcat;

    I pass the following query :

    select CRITERIA from search_attr where catsearch(CRITERIA, '%comm%', NULL) > 0;

    CRITERIA
    ---------
    comm

    The query returns only "comm". But I want the query to return all the rows containing %comm%, just like how it returns all these rows if I use the following query using LIKE:

    select CRITERIA from search_attr where CRITERIA like '%comm%';

    Any help please!!!!
    Agasimani
    OCP(10g/9i/8i/8)

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Try 'comm*'
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Thanks Paul. It worked.
    Agasimani
    OCP(10g/9i/8i/8)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width