Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can we search for a specific word in oracle...

948562Jul 12 2012 — edited Jul 12 2012
Hi,

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.
This post has been answered by Solomon Yakobson on Jul 12 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2012
Added on Jul 12 2012
7 comments
5,181 views