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)
精彩评论