SQL & PL/SQL

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

2795332Apr 20 2017 — edited Apr 20 2017

Hi,

I have BALANCE,ADDITION,RETIREMENT,ADJUSTMENT,TOTAL Column in a table with 1000 rows

can i use below statement for calculating TOTAL column value

UPDATE XXNI_IB_TBL SET TOTAL = nvl(BALANCE,0)+nvl(ADDITION,0)-abs(nvl(RETIREMENT,0))+nvl(ADJUSTMENT,0);

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2017

Added on Apr 20 2017

5 comments

214 views