ORACLE Text operations in spanned varchar2's
Posted on 2011-10-20
Greetings EE warriors,
I require to do fuzzy logic on spanned text.
if you look at the table below, I have an article that spans parts by artid (article id), and partid.
article one has three parts. The article is split at 4000 characters, due to the limitations of varchar2.
artid partid article
1 1 The quick brown dog jumped over the lazy yellow dog
1 2 The green dog watched the brown dog and then saw a tr
1 3 ee and bit it. The blue dog just went to sleep.
2 1 Three cats went up into the tree to play poker. The fir
2 2 st cat went to bid on two aces, while the second cat went
2 3 and folded. The third cat won the hand.
I need to do a "NEAR" operation on the article. The operation must pretend that the article is in whole, and not in parts, for example, tree is split between part 2 and 3. If I do a word search on tree, it must find it. Secondly, if word1 is in part 1, and word 2 is in either part 1 or part 2, it must come back true.