오라클 동적 멀티 뷰 생성 및 활용 예제

■ 오라클 동적 멀티 뷰 생성 및 활용 예제

WITH NM AS (
    SELECT 1 AS ID, '김유신' AS NAME FROM DUAL UNION ALL
    SELECT 2 AS ID, '강감찬' AS NAME FROM DUAL UNION ALL
    SELECT 3 AS ID, '이순신' AS NAME FROM DUAL
), TEL AS (
    SELECT 1 AS ID, '1111' AS TEL_NO FROM DUAL UNION ALL
    SELECT 2 AS ID, '2222' AS TEL_NO FROM DUAL UNION ALL
    SELECT 3 AS ID, '3333' AS TEL_NO FROM DUAL
), AG AS (
    SELECT 1 AS ID, 12 AS AGE FROM DUAL UNION ALL
    SELECT 2 AS ID, 23 AS AGE FROM DUAL UNION ALL
    SELECT 3 AS ID, 34 AS AGE FROM DUAL
)
SELECT NM.ID
     , NM.NAME
     , TEL.TEL_NO
     , AG.AGE
  FROM NM, TEL, AG
 WHERE 1=1
   AND NM.ID    = TEL.ID
   AND NM.ID    = AG.ID

동적뷰