title: oracle sql: update if exists else insert
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/237327/oracle-how-to-upsert-update-or-insert-into-a-table">Oracle: how to UPSERT (update or insert into a table?)</a>  </p>
  </blockquote>
  
  
  
  <p>Hi,</p>
  
  <p>I have a table in which a record has to be modified if it already exists else a new record has to be inserted.
  Oracle sql doesnt accept <code>IF EXISTS</code>, otherwise I would have done an <code>if - update - else - insert</code> query. I've looked at <code>MERGE</code> but it only works for multiple tables. What do i do?</p>