Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transform an UPDATE into a MERGE

Filipe RBNov 23 2018 — edited Nov 23 2018

Hi,

Could you please provide me the Merge SQL statement equivalent to this Update: ?

UPDATE TBL_TO_UPDATE TrgTbl

   SET REMOVE = 2

   WHERE TrgTbl.REMOVE = 7

   AND EXISTS

   (

      SELECT 1

      FROM TBL_HISTORY hist

      WHERE (TrgTbl.ANALYSIS_DATE = hist.HIST_DATE)

      AND TrgTbl.COL_UPD IN (SELECT COL_HIST FROM TBL_HISTORY WHERE HIST_DATE < TrgTbl.ANALYSIS_DATE ORDER BY HIST_DATE DESC FETCH FIRST 120 ROWS ONLY)

   );

Comments
Post Details
Added on Nov 23 2018
11 comments
1,274 views