Preview:
DECLARE
    a NUMBER := &a; -- You can change this value as needed
BEGIN
    UPDATE t SET sal = sal * 1.2 WHERE sal > a;
    DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows updated.');
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