SQL> create table t as select * from dba_objects;

Table created.

SQL> create index ix on t ( object_name );

Index created.

SQL>
SQL> declare
  2    cursor c is select * from all_objects;
  3
  4    type clist is table of c%rowtype;
  5    l_rows clist;
  6  begin
  7
  8    open c;
  9    fetch c bulk collect into l_rows;
 10    close c;
 11
 12    forall i in 1 .. l_rows.count
 13      delete from t
 14      where object_name = l_rows(i).object_name;
 15  end;
 16  /

PL/SQL procedure successfully completed.