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 previous 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

Report message to a moderator

[Message index]
 
Read Message
Read Message
Previous Topic: Cannot create DETAIL_DATASTORE when detail table is a view?
Next Topic: Html sectioning and CONTAINS query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 10:07:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.