오라클 임시 테이블 with ... as
http://geeyoming.tistory.com/m/post/72 사용 예: http://www.gurubee.net/article/67838 with TEST as ( select '1' A, '사과' B, '대구' C, '2000' D from dual union all select '1' A, '사과' B, '대구' C, '3000' D from dual union all select '1' A, '사과' B, '광주' C, '1000' D from dual union all select '1' A, '사과' B, '광주' C, '4000' D from dual union all select '2' A, '인삼' B, '파주' C, '1000' D from dual union all select..