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
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
Click Here to Expand Forum to Full Width