replace null with previous value in oracle

0

I want to make a replace of a null value by the last value before that null or null.

Using LAG in cases where I have 2 nulls or more only does the replace in the first null.

COL1 is the key, COL2 is the original value, and COL3 is the expected result.

(in the explanation in the "-" column, else is all col2)

RESOLVED

Through this question: link

example in image

    
asked by anonymous 11.04.2017 / 20:45

0 answers