SQL Row를 Col으로 변환

select seq, code_nm from code where kind = 'MSG_GROUP' order by seq

 

1	AAA
2	BBB
3	CCC
4	DDD
5	EEE

 select max(decode(seq, 1, code_nm)) col1,
       max(decode(seq, 2, code_nm)) col2,
       max(decode(seq, 3, code_nm)) col3,
       max(decode(seq, 4, code_nm)) col4,
       max(decode(seq, 5, code_nm)) col5
  from code
 where kind = 'MSG_GROUP'

 

AAA

BBB

CCC

DDD

EEE