WITH t ( 시간, 개수 ) AS ( SELECT '08', 3 FROM DUAL UNION ALL SELECT '11', 7 FROM DUAL UNION ALL SELECT '13', 10 FROM DUAL UNION ALL SELECT '15', 13 FROM DUAL UNION ALL SELECT '17', 18 FROM DUAL UNION ALL SELECT '23', 27 FROM DUAL ) SELECT a.시간 , LAST_VALUE ( 개수 IGNORE NULLS ) OVER ( ORDER BY a.시간 ) 개수 FROM t , ( SELECT LPAD ( TO_CHAR ( TO_NUMBER ( 시간 ) + level - 1 ), 2, '0' ) 시간 FROM ( SELECT MAX ( 시간 ) - MIN ( 시간 ) + 1 lv , MIN ( 시간 ) 시간 FROM t ) CONNECT BY LEVEL <= lv ) a WHERE a.시간 = t.시간 (+)