Oracle Text and Reserved Words [message #598162] |
Thu, 10 October 2013 16:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1da4d98d39e425dbe2cdd380a0dd2eae?s=64&d=mm&r=g) |
raman.kashyap
Messages: 9 Registered: July 2013
|
Junior Member |
|
|
Hi Team - I am using Oracle Text in one of my project using Lexers and Multi_column datastores. I'm facing some problem with reserved words like "and", "or", "not", "near", "within" etc. Is there any way I can ignore them within Contains query or If I can just disable their native behaviour?
SELECT * FROM CATEGORIES
WHERE CONTAINS(CATEGORYNAME, 'AND', 1) > 0
SELECT * FROM CATEGORIES
WHERE CONTAINS(CATEGORYNAME, 'OR', 1) > 0
SELECT * FROM CATEGORIES
WHERE CONTAINS(CATEGORYNAME, 'ANY OTHER SENTENCE ENDING WITH A RESERVED WORK LIKE AND', 1) > 0
Thanks,
Raman
|
|
|
|
|
|
|