PL/SQL (MOSC)

MOSC Banner

Is there a way to check the existence of a specific word from the string(Text)

edited Aug 29, 2013 5:47AM in PL/SQL (MOSC) 3 commentsAnswered
 Is there a way to check the existence of a specific word from the string.For example if the text is
"My_name_is is Uday"
If the above one is a string , i would like to check only for "is" and not "is" present in the My_name_is.
For this i would like to use Instr
So when we are using Instr("My_name_is is Uday",'is',1,1) then the output is 9.
But what i am expecting is the position of "is".

so if the string is "My name stagis and there is great road ahead"
Then i am looking at is before great.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center