Preview:
DECLARE
    v_count NUMBER;
BEGIN
    -- Open implicit cursor
    SELECT COUNT(*)
    INTO v_count
    FROM employee;

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