어떤걸 원하시는지 모르겠어서 생각한대로

WITH TB AS (

select 'HONG' AS NM, '4' AS YOIL , '1' AS "START" ,'4' AS "END" FROM DUAL UNION ALL

select 'CHOI' AS NM, '2' AS YOIL , '2' ,'3' FROM DUAL UNION ALL

select 'PARK' AS NM, '5' AS YOIL , '3' ,'4' FROM DUAL 

)

select nm,yoil,b.num as "DATE"

from tb a ,

(select level as num

from dual 

connect by level < 7

) b

where b.num between A."START" AND A."END"

order by nm,yoil,"DATE"

-- 결과

CHOI 2 2

CHOI 2 3

HONG 4 1

HONG 4 2

HONG 4 3

HONG 4 4

PARK 5 3

START 부터 END 사이의 값을 LEVEL 로 생성된 숫자로 범위 조인 해서 데이터를 만들어냅니다. 

#  윈도+ IE 가 아니라서 그런지 결과 부분이 입력된것과는 다르게

왜곡 되서 나오네요 ;