Skip to Main Content
Forums

Analytics Software

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 to use locate function if multiple occurences of same character

569196Oct 1 2010 — edited Oct 1 2010
I am trying to use the location function to find the existence of '~' in my string. My string has multiple occurences of '~' in it.
But, the locate always returns the location of first one. How can I get it to return the second occurence of '~' in the string.

Thanks in advance
kris

Edited by: user566193 on Oct 1, 2010 1:35 PM
This post has been answered by David_T on Oct 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2010
Added on Oct 1 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #function, #multiple
4 comments
4,774 views