Hi
how in Oracle build cross query like in MS Access

in MS Access I have:
TRANSFORM Sum(t1.war) AS SumaOfwar
SELECT t1.id, t1.name
FROM t1
GROUP BY t1.id, t1.name
PIVOT t1.lim;

result:
id name 3 month 5 dey
022313 Comp_A 1 00 000 10 000


source t1:
id name lim war
022313 Comp_A 5 dey 10 000,00
022313 Comp_A 3 month 100 000,00


thanks for help

t.