title: Is Oracle MERGE NOT MATCHED THEN UPDATE possible?
body: <p>We'd like to set the IS_DEL bit = 1 when a record exists in a Target table that doesn't exist in the Source table.  </p>
  
  <p>Is it possible to use a MERGE statement using the WHEN NOT MATCHED clause, but make it perform an UPDATE?</p>
  
  <p>When attempting to do so, I'm getting a "ORA-00905: missing keyword" message.</p>
  
  <pre><code>MERGE
  INTO    AMEPSA.ENTERPRISE_LOCATION trg
  USING   (
          SELECT C.LOCATION_KEY as LOCATION_KEY
          FROM AMEPSA.ENTERPRISE_LOCATION C
              INNER JOIN AMESTAGE.VW_LOCATION L ON C.REC_SRC_KEY_CD = L.LOCATION_ID    
          WHERE C.CURR_REC_IND = 'Y'
          ) src
  ON      (trg.LOCATION_KEY = src.LOCATION_KEY)
  WHEN NOT MATCHED THEN UPDATE
      SET trg.IS_DEL = 1
  </code></pre>
  
  <p>Does the "WHEN NOT MATCH" clause only support "THEN INSERT"?</p>