upper_cursor

PHOTO EMBED

Sun May 26 2024 17:33:17 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

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