title: Insert ...on duplicate in oracle?
body: <p>I am new to Oracle and I want to check if particular primary key value is present or not. If value exists then just update the entire row .If value is not present, then insert new row.</p>
  
  <pre><code>INSERT INTO table (a,b,c) VALUES (1,2,3)
    ON DUPLICATE KEY UPDATE c=c+1;
  </code></pre>
  
  <p>Code above works on MySql. How to achieve the same in Oracle 10g? Can anyone please help?</p>