Skip to Main Content

SQLcl

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.

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

Processing

Post Details

Added on Jan 23 2019
2 comments
337 views