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