DECLARE
    
  e employee%rowtype;
 empno employee.ename%type;
    
BEGIN
   update  employee 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;
/