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