Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> QUERY WRITING

QUERY WRITING

From: Segun <orefuja_at_yahoo.com>
Date: 25 Nov 2004 11:25:58 -0800
Message-ID: <3eced8bb.0411251125.1fed723c@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 Received on Thu Nov 25 2004 - 13:25:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US