'ORACLE INLINE VIEW' 태그의 글 목록

ORACLE INLINE VIEW 1

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