Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 1 ID, NULL OLD, 'X1' NEW, TO_DATE('2019-01-01', 'yyyy-mm-dd') CREATED FROM DUAL
- UNION ALL
- SELECT 1 ID, NULL OLD, 'Y1' NEW, TO_DATE('2019-01-02', 'yyyy-mm-dd') FROM DUAL
- UNION ALL
- SELECT 1 ID, 'X1' OLD, NULL NEW, TO_DATE('2019-02-01', 'yyyy-mm-dd') FROM DUAL
- UNION ALL
- SELECT 1 ID, NULL OLD, 'Z1' NEW, TO_DATE('2019-01-01', 'yyyy-mm-dd') FROM DUAL
- UNION ALL
- SELECT 1 ID, 'Y1' OLD, NULL NEW, TO_DATE('2019-03-01', 'yyyy-mm-dd') FROM DUAL
- UNION ALL
- SELECT 2 ID, NULL OLD, 'Z2' NEW, TO_DATE('2019-02-02', 'yyyy-mm-dd') FROM DUAL
- UNION ALL
- SELECT 2 ID, NULL OLD, 'X2' NEW, TO_DATE('2019-01-01', 'yyyy-mm-dd') FROM DUAL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement