orclz>
orclz> delete from emp;

14 rows deleted.

orclz> commit;

Commit complete.

orclz> insert into emp select *  from emp as of timestamp (sysdate - 10/1440);

14 rows created.

orclz> commit;

Commit complete.

orclz>

SQL> delete from emp;

14 rows deleted.

SQL> commit;

Commit complete.

SQL> alter table emp enable row movement;

Table altered.

SQL> flashback table emp to timestamp (sysdate - 10/1440);

Flashback complete.

SQL> select count(*) from emp;
  COUNT(*)
----------
        14

1 row selected.

SQL> create table emp1 as select * from emp;

Table created.

SQL> set serveroutput on;
SQL> DECLARE
  2      TYPE emp_typ
  3        IS TABLE OF emp1%ROWTYPE;
  4      emp_info EMP_TYP;
  5      l_cnt    NUMBER;
  6  BEGIN
  7      DELETE emp1
  8      returning empno, ename, job, mgr, hiredate, sal, comm, deptno bulk collect
  9      INTO
 10      emp_info;
 11
 12      COMMIT;
 13
 14      SELECT Count(*)
 15      INTO   l_cnt
 16      FROM   emp1;
 17
 18      dbms_output.Put_line('l_cnt after deletion ='
 19                           ||l_cnt);
 20
 21      FOR i IN emp_info.first..emp_info.last LOOP
 22          INSERT INTO emp1
 23          VALUES     (Emp_info(i).empno,
 24                      Emp_info(i).ename,
 25                      Emp_info(i).job,
 26                      Emp_info(i).mgr,
 27                      Emp_info(i).hiredate,
 28                      Emp_info(i).sal,
 29                      Emp_info(i).comm,
 30                      Emp_info(i).deptno);
 31      END LOOP;
 32
 33      commit;
 34
 35      SELECT Count(*)
 36      INTO   l_cnt
 37      FROM   emp1;
 38
 39      dbms_output.Put_line('l_cnt after returning the deleted rows ='
 40                           ||l_cnt);
 41  END;
 42  /
l_cnt after deletion =0
l_cnt after returning the deleted rows =14

PL/SQL procedure successfully completed.

SQL>