CREATE TABLE demo   
  ( col1 NUMBER,   
    col  NUMBER )

BEGIN 
     FOR counter IN 1..1000 LOOP 
       INSERT INTO demo 
       VALUES(counter, 
              counter); 
     END LOOP; 
   END; 

COMMIT

CREATE OR REPLACE TYPE v_n_t AS TABLE OF NUMBER; 

CREATE OR REPLACE FUNCTION delete_demo ( p_curs SYS_REFCURSOR ) 
      RETURN v_n_t AS 
      PRAGMA AUTONOMOUS_TRANSACTION; 
      v_ret_val v_n_t := v_n_t(); 
      v_number NUMBER; 
   BEGIN 
     LOOP 
       FETCH p_curs INTO v_number; 
       EXIT WHEN p_curs%NOTFOUND; 
       v_ret_val.EXTEND; 
       DELETE demo 
       WHERE col1 = v_number; 
       v_ret_val(1) := SQL%ROWCOUNT; 
     END LOOP; 
     COMMIT; 
     RETURN(v_ret_val); 
 END; 

ALTER SESSION FORCE PARALLEL QUERY

SELECT COUNT(*) 
     FROM TABLE(delete_demo(CURSOR(SELECT col1 
                                     FROM demo))) 

ALTER SESSION DISABLE PARALLEL QUERY

SELECT COUNT(*) 
     FROM demo 

BEGIN 
     FOR counter IN 1..1000 LOOP 
       INSERT INTO demo 
       VALUES(counter, 
              counter); 
     END LOOP; 
   END; 

COMMIT

CREATE OR REPLACE TYPE v_n_t AS TABLE OF NUMBER; 

CREATE OR REPLACE FUNCTION delete_demo ( p_curs SYS_REFCURSOR ) 
      RETURN v_n_t AS 
      PRAGMA AUTONOMOUS_TRANSACTION; 
      v_ret_val v_n_t := v_n_t(); 
      v_number NUMBER; 
   BEGIN 
     LOOP 
       FETCH p_curs INTO v_number; 
       EXIT WHEN p_curs%NOTFOUND; 
       v_ret_val.EXTEND; 
       DELETE demo 
       WHERE col1 = v_number; 
       v_ret_val(1) := SQL%ROWCOUNT; 
     END LOOP; 
     COMMIT; 
     RETURN(v_ret_val); 
 END; 

ALTER SESSION FORCE PARALLEL QUERY

SELECT COUNT(*) 
     FROM TABLE(delete_demo(CURSOR(SELECT col1 
                                     FROM demo))) 

ALTER SESSION DISABLE PARALLEL QUERY

SELECT COUNT(*) 
     FROM demo