[ORACLE]WITH절 예제 WITH EMP_DATA AS ( SELECT '1234' AS EMP_NO , '홍길동' AS EMP_NAME , '1980-01-01' AS BIRTHDAY FROM DUAL UNION ALL SELECT '1235' AS EMP_NO , '홍길순' AS EMP_NAME , '1981-10-05' AS BIRTHDAY FROM DUAL ) SELECT EMP_NO , EMP_NAME , BIRTHDAY FROM EMP_DATA ; ORACLE 2020.11.12