DECLARE threshold_salary NUMBER := 1000; -- You can change this value as needed BEGIN -- Using an implicit cursor to update the salary UPDATE employee SET sal = sal * 1.2 WHERE sal > threshold_salary; -- Display the number of rows updated DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows updated.'); END; /