How can we search for a specific word in oracle...
948562Jul 12 2012 — edited Jul 12 2012Hi,
Is there Oracle function that searches for a specific word? I want to search only words(not string). Please see the sample below.
text : 'oracle forum is the best'
word : 'orum'
Result : Not exists****
If we use INSTR, it says the word exists. But i want to search for word 'orum' not for the word containing 'orum'. So the result is 'word orum doesn't exists in the text'.
Thanks.