Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

sql update

0614Jan 23 2019 — edited Dec 9 2019

Hi all,

I need a small help in sql update query

please follow below structure

table

S.no     Name       sal              (sal+increment ) incsal

1            a             100             100

2            b              200             300(1st row value+ 2nd row value)

3            c              300             500 (2nd row value + 3rd row value)

4            d              400              700 (3rd row value + 4th row value)

need update statement for incsal column value to update as mentioned above

Thanks in advance

This post has been answered by Joerg.Sobottka on Jan 23 2019
Jump to Answer
Comments
Post Details
Added on Jan 23 2019
2 comments
340 views