How to sum incrementaly in Oracle 8?

I need to do an incremental sum in Oracle.

My situati开发者_如何学Pythonon is the following:

RecordID      Value

1            1
2            2
3            5
4            10

And I need to get something like this:

RecordID      Sum_incremental

1            (1)
2            (1 + 2)
3            (1 + 2 + 5)
4            (1 + 2 + 5 + 10)

The clues: self join and group by.

The solution:

select a.recordid, sum(b.value) sum_incremental from mytable a, mytable b
where b.recordid <= a.recordid group by a.recordid

select recordid, 
       sum(value) over (order by recordid)
from some_data