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