Décomposer (ou alternative) toutes les colonnes en lignes

C'est une douleur. Vous pouvez annuler le pivot et le ré-agréger. Voici une méthode:

select which,
       max(case when year = 2000 then c end) as val_2000,
       max(case when year = 2001 then c end) as val_2001,
       max(case when year = 2002 then c end) as val_2002,
       max(case when year = 2003 then c end) as val_2003
from ((select c1 as year, 'c2' as which, c2 as c from test) union all
      (select c1 as year, 'c3' as which, c3 as c from test) union all
      (select c1 as year, 'c4' as which, c4 as c from test) union all
      (select c1 as year, 'c5' as which, c5 as c from test) 
     ) x
group by which
order by which;

Ici est un db violon.

Vous transposez, pas seulement pivotez. Vous devez UNPIVOT , puis PIVOT.

select * from test
unpivot(c for col in(c2,c3,c4,c5))
pivot(max(c) for c1 in(2000,2001,2002,2003))
order by col;

CO       2000       2001       2002       2003
-- ---------- ---------- ---------- ----------
C2    1844054    1850861    1841519    1804163
C3      50.03      49.86      50.32      49.84
C4     922030     937391     907995     902838
C5      25.01      25.25      24.81      24.94

 SELECT * FROM test
 unPIVOT(
    quantity -- unpivot_clause
    FOR product_code --  unpivot_for_clause
    IN ( c2,c3,c4,c5)) 

pivot(max(quantity) for 
c1 in(2000,2001,2002,2003))
order by product_code;