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; /
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; /