context server

[mushir]

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

[ntokozo]

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