title: Merge into a select statement - Oracle
body: <p>Is it possible to filter some of the entries to be merged on a table using select? </p>
  
  <pre><code>MERGE INTO (
    SELECT * FROM P4PCA2_PIVOT_CA
    WHERE ( CA_LIG_VTE_NUM_ID_PDT &lt;&gt; 0 )
  )  ta
  USING P4DAS2_DONARTSTK tb ON (tb.NUM_ID_PDT =ta.CA_LIG_VTE_NUM_ID_PDT)    
  WHEN MATCHED THEN
    UPDATE SET ta.COD_SECVTE_REVENT=tb.COD_SECVTE_REVENT);
  </code></pre>