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