방법은 비슷하지만 이렇게도 ...

data가 문자형필드라는 가정하에..

select name, juminno,
       sum(decode(data,'1',data))  as data1,
       sum(decode(data,'2',data))  as data2,
       sum(decode(data,'3',data))  as data3,
       sum(decode(data,'4',data))  as data4,
       sum(decode(data,'5',data))  as data5,
       sum(decode(data,'6',data))  as data6,
       sum(decode(data,'7',data))  as data7,
       sum(decode(data,'8',data))  as data8,
       sum(decode(data,'9',data))  as data9,
       sum(decode(data,'10',data)) as data10
from   table_name
group  by name, juminno