DECLARE 

 v_rows_returned number;

BEGIN

 v_rows_returned := 0;
 FOR l IN (SELECT 1 FROM dual WHERE 1 = 1) LOOP
    v_rows_returned := v_rows_returned + 1;
 END LOOP;
 Dbms_Output.put_line('Rows Returned : ' || v_rows_returned);

 v_rows_returned := 0;
 FOR l IN (SELECT 1 FROM dual WHERE 1 = 2) LOOP
    v_rows_returned := v_rows_returned + 1;
 END LOOP;
 Dbms_Output.put_line('Rows Returned : ' || v_rows_returned);
 
END;
/

DECLARE 
  CURSOR c1 IS 
    SELECT 1 
    FROM   dual 
    WHERE  2 = 1; 
   a  NUMBER; 
BEGIN 
  FOR x IN c1 LOOP 
    a := c1%ROWCOUNT; 
    dbms_output.Put_line(a); 
  END LOOP; 
   
  IF a IS NULL THEN 
    dbms_output.Put_line('cursor with no values'); 
  END IF; 
END;