원문 : https://lilymate.tistory.com/479
WITH TB_MAIN AS (
SELECT LEVEL AS LV_NO
FROM DUAL
CONNECT BY LEVEL <= 3
)
, TB_SUB AS (
SELECT a.*
, SYSDATE + LV_NO AS SYSDATE_PLUS_LV_NO
FROM TB_MAIN a
)
SELECT *
FROM TB_SUB
;
출처: https://lilymate.tistory.com/479 [행이네]