Preview:
DECLARE
    a NUMBER;
BEGIN
    SELECT COUNT(*) INTO a
    FROM t;

    IF a > 0 THEN
        DBMS_OUTPUT.PUT_LINE('At least one row satisfies the condition::  '||a);
    ELSE
        DBMS_OUTPUT.PUT_LINE('No rows satisfy the condition.');
    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