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