RE: Sum of Previous Record

Have a look at analytical functions (LAG() and the like)

>----- ------- Original Message ------- -----
>From: "Walid Alkaakati"
><Walid.Alkaakati_at_astrolabeit.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Wed, 04 Jun 2003 05:10:14
>
>
>
>Hi list ,
>
>Can you help me please .
>
>I have a report that show data as follows :
>
>debit credit balance
>3 0 -3
> 0 -1 2
> 1 0 3
>
>Is their a way to get balance without using a
>separet query in a
>formula column,i .e i need the value of the
>previous
>record in the same repeating frame.
>
>Thanks
>
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>--
>Author: Walid Alkaakati
> INET: Walid.Alkaakati_at_astrolabeit.com
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and
>web hosting services
>To REMOVE yourself from this mailing list, send an
>E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of
>'ListGuru') and in
>the message BODY, include a line containing: UNSUB
>ORACLE-L
>(or the name of mailing list you want to be removed
>from). You may
>also send the HELP command for other information
>(like subscribing).
>---------------------------------------------------
>------------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).