开发者

Oracle Text: Nested Near statements

开发者 https://www.devze.com 2023-02-15 07:52 出处:网络
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

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

精彩评论

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

关注公众号