salary_cursor

PHOTO EMBED

Sat Jun 08 2024 02:20:46 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

DECLARE
    a NUMBER := &a; -- You can change this value as needed
BEGIN
    UPDATE t SET sal = sal * 1.2 WHERE sal > a;
    DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows updated.');
END;
/
content_copyCOPY