Create a crosstab report (Oracle)

oracle| Create
Create a crosstab report

CREATE TABLE T1 (
Goodid number is not NULL,
Saledate date NOT NULL,
Salesum Number (10)
);

Requirement to generate a product sales statement for each month of the year

M1 m2 m3 ... M12
G1
G2
.
.
.
Gn

The following is the SQL that generates the report

SELECT Goodid,
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "01",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "02",
SUM (To_char (saledate, ' mm '), ' decode ', salesum)) "03",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "04",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "05",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "06",
SUM (Decode (To_char (saledate, ' mm '), ' modified ', salesum)) "07",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "08",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum)) "09",
SUM (Decode (To_char (saledate, ' mm '), ' ten ', Salesum)) "10",
SUM (Decode (To_char (saledate, ' mm '), ' one ', salesum)) "11",
SUM (Decode (saledate, ' mm '), ' To_char ', salesum) "12"
from T1
where To_char (saledate, ' yyyy ') = ' 2004 '
GROUP BY Goodid
Order BY Goodid;