implicit_cursor

PHOTO EMBED

Sat Jun 08 2024 02:22:13 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

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