Re: Computing cumulative values with SQLplus

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Fri, 7 Aug 1998 13:54:49 +0100
Message-ID: <6qeteb$5r1$1@schbbs.mot.com>

SUM will onyl give you a total at break levels in SQL*PLus. I suspect you'll need your PL/SQL script and use it to populate a temporary table and drive your report from that.

I've not managed to solve this any other way so if you get lucky, let me know.

--
Alan D. Mills

Ed Prochak wrote in message <35CA7626.5B73_at_interfacefamily.com>...
>Alan Long wrote:
>> What I want is to add a column showing the cumulative quantity, like
>>
>
>Look into your manual for the SUM() function.
Received on Fri Aug 07 1998 - 07:54:49 CDT