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

Thread: context server

  1. #1
    Join Date
    Oct 2000

    Hi everyone!
    I am trying to use context server or any other way to find words in a column value positioned at different location.

    e.g column value = 'microsoft-wheeler object value position'

    i want to get this value by passing 'object position' or 'wheeler' without using '%' wildcard character because it will make the query very slow



  2. #2
    Join Date
    Sep 2000
    Hi Mushir,

    you can do searches on LOB's etc.

    Do you have a specific question, or are you interested
    in learning more?

    As I understant it, the context server is part of interMedia
    text package, and generally used following these steps:

    1. user must be granted CTXAPP privilege

    2. CTXSYS.CONTEXT type index has to be created on
    the table (column) to be searched

    3. you can then execute a CONTAINS query on the
    indexed column


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.