SQLPLUS question

i hope some expert can help me on this..

I need to produce a report in SQLPLUS which prints out rows.. easy so far.. but the final column has to be an accumulation of each of the previous rows.

e.g.

Account Debt Accumulated Debt

A01         21       	 21 
A02         40		 61
A03	    50		 111
A04         90		 201

I cant get the final column to appear even though I've tried GROUP BY, COMPUTE, BREAK ON PRIOR etc

I would appreciate any help.

Pratik    Received on Tue Feb 21 1995 - 20:54:07 CET