Guest User

Untitled

a guest
Oct 14th, 2018
367
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.77 KB | None | 0 0
  1. merge INTO cdt_dict_values A using(
  2. SELECT * FROM cdt_dict_values
  3. AS OF TIMESTAMP (Sysdate-2/24)
  4. MINUS
  5. SELECT * FROM cdt_dict_values
  6. ) B
  7. ON (A.dvl_code=B.DVL_CODE AND A.DVL_LNG_ID=B.DVL_LNG_ID AND A.DVL_DST_FIELD=B.DVL_DST_FIELD AND A.DVL_DCT_ID=B.DVL_DCT_ID)
  8. WHEN NOT MATCHED THEN
  9. INSERT (A.DVL_ACTIVE, A.DVL_AUDIT_CD,A.DVL_AUDIT_CU, A.DVL_AUDIT_MD, A.DVL_AUDIT_MU, A.DVL_CODE, A.DVL_DCT_ID, A.DVL_DICT_ACTIVE, A.DVL_DST_FIELD, A.DVL_DVL_ID, A.DVL_ID, A.DVL_LNG_ID, A.DVL_ORDER_BY, A.DVL_ROUTING_ID, A.DVL_VALUE)
  10. VALUES (B.DVL_ACTIVE, B.DVL_AUDIT_CD,B.DVL_AUDIT_CU, B.DVL_AUDIT_MD, B.DVL_AUDIT_MU, B.DVL_CODE, B.DVL_DCT_ID, B.DVL_DICT_ACTIVE, B.DVL_DST_FIELD,B.DVL_DVL_ID, (SELECT MIN(dvl_id)-1 FROM cdt_dict_values) ,B.DVL_LNG_ID, B.DVL_ORDER_BY, B.DVL_ROUTING_ID, B.DVL_VALUE)
Add Comment
Please, Sign In to add comment