오라클 행 열 바꾸는거 decode max 안쓰고

with t(dt, a, b, c, d, e, f) as
(
 select 1101 ,1 ,2 ,3 ,4 ,5 ,6 from dual union all
 select 1102, 2, 3, 4, 5, 6, 1 from dual union all
 select 1103, 3, 4, 5, 6, 1, 2 from dual union all
 select 1104, 4, 5, 6, 1, 2, 3 from dual union all
 select 1105, 5, 6, 1, 2, 3, 4 from dual 
)
select *
from (
  select * 
  from t
  unpivot include nulls
  (val for Character in (a,b,c,d,e,f))
  )
pivot (max(val) for dt in (1101,1102,1103,1104,1105))
order by Character;

 

참조 :http://www.oracleclub.com/article/60345