oracle - update using for loop in plsql - Stack Overflow

oracle - update using for loop in plsql - Stack Overflow

瀏覽:1184
日期:2025-06-09
i'm having problem updating and insert into below column. Please advise on this. This is the input depnto extra comm ----- 20 300 NULL 20 300 400... ... You do not need FOR LOOP, just a single UPDATE does the work: UPDATE emp SET comm = extra WHERE ......看更多