开发者

Oracle Text: Nested Near statements

I need to find documents in an Oracle Text index that satisfies multiple proximity conditions. For example, the word "cat" near the word "biologist" and then that combination near the word "Idaho". Is there any way to do this other than having three "Near" statements connected with "And"; such as, "near((cat, bio开发者_Go百科logist), 10, FALSE) and near((cat, Idaho), 10, FALSE) and near((biologist, Idaho), 10, False)"?


http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cqoper.htm#i997808

It seems that you can specify as many words as you want:

NEAR((cat,biologist,Idaho),10,FALSE)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜