SQL & PL/SQL

How SQL%ROWCOUNT works ...............plz help


PL/SQL code is:



SET SERVEROUTPUT ON

DECLARE
avg_1 NUMBER;
avg_2 NUMBER;
var_rows NUMBER;
BEGIN
SELECT AVG(salary) INTO avg_1 FROM employees where department_id=10;
SELECT AVG(salary) INTO avg_1 FROM employees where department_id=20;

if avg_1 > avg_2 THEN

UPDATE employees SET salary=(salary *20/100)+ salary
where department_id=20;

IF SQL%NOTFOUND THEN

dbms_output.put_line('None of the salaries where updated');

ELSIF SQL%FOUND THEN

var_rows := SQL%ROWCOUNT;

dbms_output.put_line('Salaries for ' || var_rows || 'employees are updated');

END IF;
end if;
end;





anonymous block completed

PL/SQL procedure successfully completed.

The PLSQL Procedure was executed succesfully.
But DBMS_OUTPUT.PUT_LINE(v_count); have not displayed anything.

How SQL%ROWCOUNT works?