DataBase/Oracle

[Oracle] With구문 다중 사용 (2절 이상)

MinaChae 2021. 1. 13. 18:31
WITH A_TB AS (SELECT 'I''m A' AS column_name FROM DUAL)
       , B_TB AS (SELECT 'I''m B' AS column_name FROM DUAL)
SELECT A.column_name, B.column_name
    FROM A_TB A
    FULL OUTER JOIN B_TB B
    ON A.column_name = B.column_name
;

*Oracle 9 이상 지원됨.