Report formating

[Matsul]

I am running a query

select type,date,count(*)
from tableA
group by type,date;

that gives me data as follows in a more simple example;

Type Date Count
A 1-12-04 100
B 1-12-04 50
D 1-12-01 150
A 2-12-04 75
B 2-12-01 40

Is there a way in PL/SQL to 'transpose' the data to get a report as follows

Date
-------------------
Type |1-12-04 2-12-04
|
A |100 75
B |50 40
D |150


thanks

 

[RolandTheRoadie]

You're going to have to use a DECODE statement on the query to evaluate the dates.

Try something like:

Select Type,
Count(Decode(date,To_Date('01-12-04','MM-DD-YY'),1)) "01-12-04",
Count(Decode(date,To_Date('02-12-04','MM-DD-YY'),1)) "02-12-04"
From TableA
Group By Type