Matrix report in SQL*Plus

Hi,

[Quoted] Does anyone have a smart technique for writing a sql-script to produce a matrix report from a single tables data. The table looks like this:

Field 1		2	3
Sector	   Country	Value
------------------------------
Banking 	US	12.6
Banking		NL	 2.6
Banking		JP	 8.6
Industri	US	10
Industri	NL	30
Industri	JP	45

I would like the report to look like this

		US	NL	JP
Banking		12.6	2.6	8.6
Industri	10	30	45

Any suggestions would be very appricated !

Regards,

Per Elmgreen Received on Tue Jul 29 1997 - 00:00:00 CEST