title: Deleting rows from multiple related tables
body: <p>There are three tables related one-to-one on the identifier. I need to delete all the records from the three tables that match the criteria A.ID = B.ID = C.ID</p>
  
  <p>Now I do it in the following way:</p>
  
  <pre><code>DECLARE
      CURSOR CUR IS 
          SELECT C.ID FROM A 
          INNER JOIN B ON A."ID" = B."ID" 
          INNER JOIN C ON B."ID" = C."ID"
          WHERE A.STATUS = 'ERROR';
      IDX NUMBER;
  BEGIN
      FOR REC IN CUR LOOP 
          IDX := REC.ID;
          DELETE FROM C WHERE C."ID" = IDX;
          DELETE FROM B WHERE B."ID" = IDX;
          DELETE FROM A WHERE BP."ID" = IDX;
      END LOOP;
      COMMIT;
  END;
  </code></pre>
  
  <p>A lot of data and this way for very long runs. Is there any way to delete faster?</p>