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