0

I have data looking like this:

ID      CONTENT
1474    1442,1522,1420
1472    1442,1419
1473    1442,1418
1674    1442,1493,1523,1421

I want output like

ID    ID2
1474  1442
1474  1522
1474  1420

etc. etc.

Im trying to use connect by:

SELECT id,regexp_substr(content, '[^,]+', 1, LEVEL) AS doc_id,level
FROM   (
       ...
       )
CONNECT BY  regexp_count(content, '[^,]+') >= LEVEL

But i'm missing something clearly, because instead of 11 rows (in this case), i've got dozens.. Can anyone help?

Regards

q4za4
  • 630
  • 4
  • 12

0 Answers0