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

Thread: context server

  1. #1
    Join Date
    Oct 2000
    Posts
    2

    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

    Thanks

    Mushir

  2. #2
    Join Date
    Sep 2000
    Posts
    5
    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


    success?
    ntokozo

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