Connect By Level <= n 을 통한 행복제는
오직 한건의 자료만 가지고 해야 합니다.
여러건의 자료를 가진 집합에 바로 적용하시면 시스템 뻗어요.
http://www.gurubee.net/article/55635
WITH t AS ( SELECT 1 id, 'A' cd, 1 s_no, 10 e_no FROM dual UNION ALL SELECT 2, 'B', 11, 15 FROM dual UNION ALL SELECT 3, 'A', 16, 20 FROM dual UNION ALL SELECT 4, 'C', 21, 30 FROM dual UNION ALL SELECT 5, 'A', 31, 35 FROM dual ) SELECT id, cd, s_no, e_no , s_no + lv - 1 lv FROM t , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 99) WHERE lv <= e_no - s_no + 1 AND cd = 'A' ORDER BY lv ;