Dear Experts,

I have these codes

Create Cursor table1 (sno N(3), ratio N(5,2))
Insert Into table1 Values(1,5.6)
Insert Into table1 Values(2,0)
Insert Into table1 Values(3,0)
Insert Into table1 Values(4,7.8)
Insert Into table1 Values(5,0)
Insert Into table1 Values(6,0)
Insert Into table1 Values(7,3)
Insert Into table1 Values(8,0)

The result looks like this
Attachment 1
https://ibb.co/2c1LxBG

But I need this result
Attachment 2
https://ibb.co/GdNbW0x

Example:

record 1

ratio is 5.60

record 2

ratio 0

Want to fill record 2 with 5.60 until next ratio is found.

Please