Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> QUERY WRITING
Hi all,
I have a table with data as shown below
PRODUCT ENGLAND USA FRANCE IRELAND
Orange 100 101 100 90 Mango 110 110 110 80 Pawpaw 100 120 112 100 Grape 105 130 124 115 Banana 115 140 100 150
Can someone please help generate a code to produce an output as shown below
PRODUCT QUANTITY
Orange 391 Mango 410 Pawpaw 432 Grape 474 Banana 505
Thanks all, while expecting the reply urgently.
Olu Received on Thu Nov 25 2004 - 13:25:58 CST