Skip to Main Content
Forums

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!

Return multi occurence of a search string value within a column

user524911Mar 18 2008 — edited Mar 20 2008
I'm looking for help on how to return multi occurences of a search string value within column:

example:

col1
-----
<abdcduet>ihgtf<qccbbk>wwuwy<qquptio>

select substr(col1,instr(col1,'<')),(instr(col1,'>'))) col1 from tabl1

results :

col1
-----
bdcduet

However, I will like to return all the search occurrences in col1.

Message was edited by:
user524911
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2008
Added on Mar 18 2008
19 comments
3,170 views