title: ORACLE 10G DELETE USING FORALL
body: <p>I have a txn table which is having 2 million rows every month i am loading data into that using stored procedure. I need to delete the transactions using the following if it failed during my process and i used to load again .</p>
  
  <pre><code>Table TXN structure
  
  TXN_ID    NUMBER primary key 
  TXN_AMT   number
  YEAR    varchar2
  MONTH   varchar2
  </code></pre>
  
  <p>Can i used bulk collect here, but in where clause i need</p>
  
  <pre><code>DELETE FROM TXN WHERE YEAR=cYear and Month=cMonth 
  </code></pre>
  
  <p>please advice how i can make it fast</p>