OraFAQ Forum: Text & interMedia » Oracle Text and Reserved Words

Home » Server Options » Text & interMedia » Oracle Text and Reserved Words (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Text and Reserved Words [message #598162]

Thu, 10 October 2013 16:54

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

Report message to a moderator

Re: Oracle Text and Reserved Words [message #598163 is a reply to message #598162]

Thu, 10 October 2013 17:15

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

There are various things that you could do. For example, you could use the REPLACE function to remove those words from your search string or you could escape the words by enclosing them within { and }, causing them to be treated as regular text, instead of reserved words.

Report message to a moderator