Preview:
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;
/
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter