Home » Server Options » Text & interMedia » Escape OT key words? (10.2 WinXP)
Escape OT key words? [message #284704] Fri, 30 November 2007 11:12 Go to next message
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
Re: Escape OT key words? [message #284725 is a reply to message #284704] Fri, 30 November 2007 12:41 Go to previous message
ashtonkm
Messages: 10
Registered: August 2007
Junior Member
Never mind I figured out the solution. I just need to surround the reserved words with {}
Previous Topic: Cannot create DETAIL_DATASTORE when detail table is a view?
Next Topic: Html sectioning and CONTAINS query
Goto Forum:
  


Current Time: Thu Mar 28 11:23:01 CDT 2024