implicit_cursor

PHOTO EMBED

Sun May 26 2024 17:46:48 GMT+0000 (Coordinated Universal Time)

Saved by @exam123 

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