Oracle SQL: Get the previous values

Question

I have two columns table: Id, and value.

ID	Value
1
2	AA
3
4	BB
5
6
7
8	CC
9

question from:https://stackoverflow.com/questions/65925992/oracle-sql-get-the-previous-values

Answer 1

select id, last_value(value IGNORE NULLS) over (order by id) as modified_value
from   your_table
;