Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: QUERY WRITING
"Segun" <orefuja_at_yahoo.com> a écrit dans le message de
news:3eced8bb.0411251125.1fed723c_at_posting.google.com...
> 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
select product, england+usa+france+ireland quantity from my_table;?
-- Regards Michel CadotReceived on Thu Nov 25 2004 - 13:46:54 CST