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)
 

마농님, 최성준님

답변 감사합니다.