❌이전글/이전글
오라클(ORACLE) - FULL OUTER JOIN ANSI에서 오라클로 변환
ANSI FULL OUTER JOIN표현을 오라클 문법으로 표현해보자! #테스트를 위한 데이터 준비! WITH EMP1 AS ( SELECT 1 A, 2 B, 3 C FROM DUAL UNION ALL SELECT 2 A, 2 B, 3 C FROM DUAL UNION ALL SELECT 3 A, 2 B, 3 C FROM DUAL UNION ALL SELECT 5 A, 2 B, 3 C FROM DUAL ), EMP2 AS ( SELECT 1 A, 2 B, 3 C FROM DUAL UNION ALL SELECT 2 A, 2 B, 3 C FROM DUAL UNION ALL SELECT 4 A, 2 B, 3 C FROM DUAL ) SELECT * FROM EMP1 UNION ALL SELECT TO_NUMBE..
