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 이상 지원됨.