Skip to Main Content
Forums

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2007
Added on Nov 6 2007
12 comments
4,634 views