ORACLE ROW를 COL로 썸네일형 리스트형 [ORACLE]오라클의 ROW를 COL 형태로 변환 오라클의 ROW를 COL 형태로 변환 상수가 물어봐서 한 김에 정리함 select usr , max(mon01) as mon01 , max(mon02) as mon02 , max(mon03) as mon03 from ( select usr, lvl, amt , case when lvl = '1' then amt else 0 end as mon01 , case when lvl = '2' then amt else 0 end as mon02 , case when lvl = '3' then amt else 0 end as mon03 from ( with usr as ( select 'lsk' as usr from dual union all select 'lss' as usr from dual ) select *.. 더보기 이전 1 다음