[Oracle] With 문 사용(Full Join) - 카테시안 조인

with test1 as ( select 'EQ1' as ttt from dual union select 'EQ2' as ttt from dual ), test2 as ( select * from "테스트 할 테이블명" ) select * from test1, test2 where ttt = 'EQ1' 임시테이블 EQ1, EQ2를 만들어서, 테스트할 테이블과 JOIN해서 보여줄때 사용함. =========================================== 응 용 ========================================> with test1 as ( select 'EQ_A' as eq ,'F' as ilsang from dual union select 'EQ_B' as eq, '..

원문링크 : [Oracle] With 문 사용(Full Join) - 카테시안 조인