CONNECT BY LEVEL 활용한 순서 채번

1. 연속된 숫자

SELECT LEVEL - 1 AS HOUR  
FROM DUAL  
CONNECT BY LEVEL <= 24

 

실행결과

 

2.  특정날짜

SELECT TO_DATE('20240901', 'YYYYMMDD') + (LEVEL-1) AS DT
FROM DUAL
CONNECT BY LEVEL <= (TO_DATE('20240915', 'YYYYMMDD') - TO_DATE('20240901', 'YYYYMMDD')) + 1
;

 

실행결과