Skip to Main Content

Inverse WM_CONCAT()

644238Mar 12 2009 — edited Mar 12 2009
Having the following data:

{color:#0000ff}338033 2 531030 142062
338033 2 531010 142062
338033 2 530010 142062{color}

... I use WM_CONCAT() to get:

{color:#0000ff}338033 2 531030,531010,530010 142062{color}

Now what I am looking for is the way around -> Converting the 1 agregated record to the 3 initial records.

I thought I'll ask before starting to program some PL/SQL loops...

Thx,
Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Apr 9 2009
Added on Mar 12 2009
7 comments
1,599 views