OraFAQ Forum: Text & interMedia » Escape OT key words?

Home » Server Options » Text & interMedia » Escape OT key words? (10.2 WinXP)

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

Escape OT key words? [message #284704]

Fri, 30 November 2007 11:12

ashtonkm
Messages: 10
Registered: August 2007

Junior Member

Is there a way escape Oracle Text keywords? For example suppose I wanted to find the rows with the words "fuzzy" and "animal". I would want to do it in the following way:

select *
from entry a
where 
((contains(a.text,'fuzzy and animal', 1) > 0 )

However I cannot do this because "fuzzy" is a reserved word in Oracle Text. Anyway have an idea how I might do this?

Thanks

Report message to a moderator

Re: Escape OT key words? [message #284725 is a reply to message #284704]

Fri, 30 November 2007 12:41

ashtonkm
Messages: 10
Registered: August 2007

Junior Member

Never mind I figured out the solution. I just need to surround the reserved words with {}

Report message to a moderator

Previous Topic:	Cannot create DETAIL_DATASTORE when detail table is a view?
Next Topic:	Html sectioning and CONTAINS query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 19 00:28:37 CST 2021