PL/SQL transforming table output ?????

From: <ajamoughlir_at_iccgcc.cle.ab.com>
Date: 1 Mar 95 13:52:50 EST
Message-ID: <1995Mar1.135250.1_at_iccgcc.cle.ab.com>


Hi,

i have the follwoing table:

	column1 column2
        -------	-------
Row1	x1	 10
Row2	x2       20
Row3	x3	 20
Row4    x1       20
Row5    x2       10
Row6    x3       10
.       .         .

and so on..

what i need to do is to get my output in the follwoing format:

	x1	x2	x3
	--	--	--
Row1	10	20      20
Row2	20	10	10

any help would be appreciated!

Thanks Received on Wed Mar 01 1995 - 19:52:50 CET

Original text of this message