Inverse WM_CONCAT()
644238Mar 12 2009 — edited Mar 12 2009Having 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