Need to split string with repeated words in seperate row in oracle

Asked Oct 04 '17 at 12:12

Active Oct 04 '17 at 12:34

Viewed 95 times

Hi i need help in splitting column into rows where ever repeated words are coming.

 p_id        Name

 92222       MCD45-Quantum Red<REF ID="1552" TYPE="trademark"/>
             TRI-TAG<REF ID="4684" TYPE="trademark"/>

i want to break into rows where TYPE="trademark" is coming for ex :

p_id           Name 

92222          MCD45-Quantum Red<REF ID="1552" TYPE="trademark"/>
92222          TRI-TAG<REF ID="4684" TYPE="trademark"/>

It is dynamic and not known that how many times REF ID will come in column string.for checking that i have used code :

regexp_count(name,'trademark') > 1

Can you please suggest how to do this.

asked Oct 04 '17 at 12:12

Animesh Sheolikar

Multiple methods in those linked questions - just change the delimiter. – MT0 Oct 04 '17 at 12:35
yes correct but i am finding difficult in finding delimiter in current situation – Animesh Sheolikar Oct 04 '17 at 13:45
Use `TYPE="trademark"/>` as the delimiter and then append it back onto the string? – MT0 Oct 04 '17 at 13:50

0 Answers0