title: Insert if not exists Oracle
body: <p>I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like:</p>
  <pre><code>INSERT ALL
      IF NOT EXISTS( SELECT 1 WHERE fo.primary_key='bar' )
      (
          INSERT INTO 
              schema.myFoo fo ( primary_key, value1, value2 )
          VALUES
              ('bar','baz','bat')
      ),
      
      IF NOT EXISTS( SELECT 1 WHERE fo.primary_key='bar1' )
      (
          INSERT INTO 
              schema.myFoo fo ( primary_key, value1, value2 )
          VALUES
              ('bar1','baz1','bat1')
      )
  SELECT * FROM schema.myFoo;
  </code></pre>
  <p>Is this at all possible with Oracle?</p>
  <p><sub>Bonus points if you can tell me how to do this in PostgreSQL or MySQL.</sub></p>