SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Carry Forward

546431Nov 6 2007 — edited Oct 29 2010

Hi All

I was just wondering if there is any function out there to carry forward a value onto x number of lines. I am not using version 10 so I am unable to use last_value.

Basically I have a column such as the one shown below. Where ever there is a null value I need to bring down the last value. Any ideas on how to achieve this?

ID COL_A COL_B
1 10 10
2 NULL 10
3 30 30
4 40 40
5 NULL 40
6 NULL 40
7 NULL 40
8 50 50
9 NULL 50
10 60 60

Any help would be great

Michelle

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2007

Added on Nov 6 2007

12 comments

4,536 views