SELECT CODE, CNT FROM TABLE;
CODE CNT
A 3
B 2
일때
자동으로 ROW가
A 1
A 2
B 1
가 되도록 할 수 있는지 질문 드립니다.
WITH t AS ( SELECT 'A' code, 3 cnt FROM dual UNION ALL SELECT 'B', 2 FROM dual ) SELECT code , cnt , lv FROM t , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 9) WHERE lv <= cnt ORDER BY code, lv ; http://www.gurubee.net/article/55635
select code,column_value rn from t,table(cast(multiset(select level from dual connect by level <= t.cnt) as sys.OdciNumberList))
위에 건 위분 URL로 들어가면 비슷한게 있네요
가장 비슷하지 않은걸로 하나 추가요
select * from t,TABLE(select collect(level) from dual connect by level<= t.cnt)
마농님, 최성준님
답변 감사합니다.