Re: Computing cumulative values with SQLplus

Alan Long wrote:
> What I want is to add a column showing the cumulative quantity, like
>
> part qty cum
> aa 2 2
> ab 5 7
> ac 1 8
> etc
>
> Any idea how this can be done, with Oracle 7.3 SQLplus? I know I can do it with
> PL/SQL but this is a second-best solution.
>

Look into your manual for the SUM() function. Received on Thu Aug 06 1998 - 22:36:06 CDT