Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- merge INTO cdt_dict_values A using(
- SELECT * FROM cdt_dict_values
- AS OF TIMESTAMP (Sysdate-2/24)
- MINUS
- SELECT * FROM cdt_dict_values
- ) B
- 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)
- WHEN NOT MATCHED THEN
- 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)
- 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