[Oracle] (With절 사용)열을 행으로 변환쿼리!!

with test1 as ( select 'EQ1' as code, '대정수' as item , '2001-08-15' as dtm from dual union select 'EQ1' as code, '소정수' as item , '2001-11-15' as dtm from dual union select 'EQ1' as code, '대정수' as item , '2002-02-15' as dtm from dual union select 'EQ1' as code, '소정수' as item , '2002-04-15' as dtm from dual union select 'EQ1' as code, '고정수' as item , '2001-07-15' as dtm from dual ) SELECT CODE, ite..

원문링크 : [Oracle] (With절 사용)열을 행으로 변환쿼리!!