DECLARE
TYPE big_tab_type IS TABLE OF
scott.big_tab.object_id%TYPE;
mybig_tab big_tab_type;
summe NUMBER:=0;
BEGIN
SELECT object_id BULK COLLECT INTO mybig_tab
FROM scott.big_tab;
FORALL i IN mybig_tab.first .. mybig_tab.last
DELETE FROM scott.big_tab
WHERE object_id=mybig_tab(i);
END;
/