DECLARE em t%rowtype; empno t.ename%type; BEGIN update t set ename=upper(ename); if sql%found then DBMS_OUTPUT.PUT_LINE(sql%rowcount||' values updated to uppercase.'); else dbms_output.put_line('not found'); end if; END; /
DECLARE em t%rowtype; empno t.ename%type; BEGIN update t set ename=upper(ename); if sql%found then DBMS_OUTPUT.PUT_LINE(sql%rowcount||' values updated to uppercase.'); else dbms_output.put_line('not found'); end if; END; /