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!

Extracting tag values from string

partlycloudyNov 7 2016 — edited Nov 7 2016

Oracle 12.1

Given the following table & data, how can I extract the values between the TAG tags for each record?

Thanks

create table foo(i int,str clob)

insert into foo values (1,'keyword1;keyword2;<tag>value1</tag>keyword3<tag>value2</tag>');

insert into foo values (2,'keyword1;keyword2;keyword3<tag>value</tag>keyword4;keyword5<tag>value4</tag>');

Output:

1 value1

1 value2

2 value

2 vaue4

This post has been answered by Frank Kulash on Nov 7 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2016
Added on Nov 7 2016
17 comments
2,856 views