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