title: Oracle MERGE statement in H2 database
body: <p>We started to use the H2 in memory database for automated testing. We use Oracle for our production &amp; dev environments. So the idea is to duplicate the table structure in H2 test-database as it is in our Oracle dev-database.</p>
  
  <p>The Oracle SQL statements include MERGE statements and use alias for table names and USING in the query.</p>
  
  <p>How can I modify this query dynamically to be compatible with H2 in a way that it does not alter the existing query in the dev environment?</p>
  
  <p>Example of the Oracle SQL, to be made compatible with H2,</p>
  
  <pre><code>MERGE INTO TABLE T1
  USING ( SELECT ....
          ...........
          FROM DUAL) T2
  </code></pre>
  
  <p>(T1 &amp; T2 are the alias for the table)</p>