Hi there, Need some help here please. Sorry new to Oracle. I'm working with Oracle 10g. I have a table like this; ID Amount Date 123 5000 Oct-07-2011 123 null Oct-09-2011 124 7000 Oct-14-2011 124 null Oct-17-2011 124 null Oct-24-2011 What I'm trying to do here is loop thruogh the records and update the amount that's null with the previous amount with the same ID. Some sample code that I follow for this? Thanks very much for your help.