نمایش Union بصورت Columnar

select id,
       sum(decode(x, 1, cnt, 0)) c1,
       sum(decode(x, 2, cnt, 0)) c2,
       sum(decode(x, 3, cnt, 0)) c3,
       sum(decode(x, 4, cnt, 0)) c4
  from (select 1 id, 10 cnt, 1 x
          from dual
        union all
        select 2 id, 20 cnt, 2 x
          from dual
        union all
        select 3 id, 30 cnt, 3 x
          from dual
        union all
        select 4 id, 40 cnt, 4 x
          from dual
     )
 group by id order by id

ID   C1   C2   C3   C4

1    10    0    0    0
2    0    20    0    0
3    0    0    30    0
4    0    0    0    40