info.michael-simons.eu

DECLARE
  TYPE id_table IS TABLE OF NUMBER;
  objekt_ids id_table;
BEGIN
    SELECT id
    BULK COLLECT INTO objekt_ids
    FROM   irgendwas
    WHERE  irgendwasanderes = 'wasweißich';
 
    FORALL idx IN objekt_ids.first .. objekt_ids.last
      DELETE FROM table1 WHERE objekt_id = objekt_ids(idx);
 
    FORALL idx IN objekt_ids.first .. objekt_ids.last
      DELETE FROM table2 WHERE objekt_id = objekt_ids(idx);
 
    -- ...
END;

DECLARE TYPE id_table IS TABLE OF NUMBER; objekt_ids id_table; BEGIN SELECT id BULK COLLECT INTO objekt_ids FROM irgendwas WHERE irgendwasanderes = 'wasweißich'; FORALL idx IN objekt_ids.first .. objekt_ids.last DELETE FROM table1 WHERE objekt_id = objekt_ids(idx); FORALL idx IN objekt_ids.first .. objekt_ids.last DELETE FROM table2 WHERE objekt_id = objekt_ids(idx); -- ... END;

DECLARE
  TYPE id_table IS TABLE OF NUMBER;
  objekt_ids id_table;
BEGIN
  IF(objekt_ids.COUNT > 0)THEN
    SELECT id
    BULK COLLECT INTO objekt_ids
    FROM   irgendwas
    WHERE  irgendwasanderes = 'wasweißich';
 
    FORALL idx IN objekt_ids.first .. objekt_ids.last
      DELETE FROM table1 WHERE objekt_id = objekt_ids(idx);
 
    FORALL idx IN objekt_ids.first .. objekt_ids.last
      DELETE FROM table2 WHERE objekt_id = objekt_ids(idx);
 
    -- ...
  END IF;
END;

DECLARE TYPE id_table IS TABLE OF NUMBER; objekt_ids id_table; BEGIN IF(objekt_ids.count > 0)THEN SELECT id BULK COLLECT INTO objekt_ids FROM irgendwas WHERE irgendwasanderes = 'wasweißich'; FORALL idx IN objekt_ids.first .. objekt_ids.last DELETE FROM table1 WHERE objekt_id = objekt_ids(idx); FORALL idx IN objekt_ids.first .. objekt_ids.last DELETE FROM table2 WHERE objekt_id = objekt_ids(idx); -- ... END IF; END;