[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

;