title: Deleting multiple rows in oracle
body: <pre><code>DELETE FROM MYTABLE WHERE ID = 1 and NAME ='xyz';
  DELETE FROM MYTABLE WHERE ID = 2 and NAME ='abc';
  DELETE FROM MYTABLE WHERE ID = 3 and NAME ='abc';
  </code></pre>
  
  <p>I have multiple delete statements mentioned above. How can I delete them in less statements. Will I have to write 100 delete statements?</p>