Matrix arrangement

From: Pierre <pierre.olaru_at_citicorp.com>
Date: 20 May 2002 02:27:48 -0700
Message-ID: <5e0672c6.0205200127.73e6249@posting.google.com>

Gents,

I would be grateful if you can help me in the following issue. I have a pertial result of a ROLLUP based query which I would like to store on a Oracle table in a different format.

Time       Region        Department        Profit
----       ------        ----------        ------
1996       Central       VideoRental       75,000
1996       Central       VideoSales        74,000
1996       East          VideoRental       89,000
1996       East          VideoSales       115,000 
1996       West          VideoRental       87,000 
1996       West          VideoSales        86,000

Practically, I would like to arrange this result in the following matrix format:

o On columns I want to have Time, Region, VideoRental, VideoSales o On rows I want to have Time, Region and the Profit which is associated which each Department

Despite the fact that there are other tools which can arrange this information in the format required
(like Excel, Discoverer or Oracle reports) I would like to store this information in a Oracle table.

Thanks in advance,
Pierre Received on Mon May 20 2002 - 04:27:48 CDT