Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MERGE INTO T_OR_ONHOLD t
- USING
- (SELECT DISTINCT
- ORDER_RELEASE_XID AS OR_XID,
- trunc(sysdate()) AS CURRENT_DAY
- FROM -- tu Ci brakuje tabeli :D
- WHERE
- STATUS_VALUE_37 LIKE '%.ON HOLD') s
- ON (t.ORDER_RELEASE_XID = s.or_xid)
- ----------- tego nie jestem pewien, prawdopodobnie można to ominąć i zostawić tylko "when not matched"
- WHEN MATCHED THEN
- NULL;
- -------------------------------
- WHEN NOT MATCHED THEN
- INSERT (ORDER_RELEASE_XID, kolumna_z_datą) -- nie wiem jak się nazywa kolumna z datą w którą będziesz chciał włożyć current_day
- VALUES (s.OR_XID, s.CURRENT_DAY);
- UPDATE
- T_OR_ONHOLD t
- SET t.OR_ONHOLD_DEL_DAY = sysdate
- WHERE
- t.OR_ONHOLD_INS_DAY IS NOT NULL
- AND
- t.ORDER_RELEASE_XID NOT IN (SELECT DISTINCT
- ORDER_RELEASE_XID AS OR_XID,
- trunc(sysdate()) AS CURRENT_DAY
- FROM -- tu Ci brakuje tabeli :D
- WHERE
- STATUS_VALUE_37 LIKE '%.ON HOLD')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement