Advertisement
Guest User

Untitled

a guest
Sep 30th, 2019
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.62 KB | None | 0 0
  1. SELECT 1 ID, NULL OLD, 'X1' NEW, TO_DATE('2019-01-01', 'yyyy-mm-dd') CREATED FROM DUAL
  2. UNION ALL
  3. SELECT 1 ID, NULL OLD, 'Y1' NEW, TO_DATE('2019-01-02', 'yyyy-mm-dd') FROM DUAL
  4. UNION ALL
  5. SELECT 1 ID, 'X1' OLD, NULL NEW, TO_DATE('2019-02-01', 'yyyy-mm-dd') FROM DUAL
  6. UNION ALL
  7. SELECT 1 ID, NULL OLD, 'Z1' NEW, TO_DATE('2019-01-01', 'yyyy-mm-dd') FROM DUAL
  8. UNION ALL
  9. SELECT 1 ID, 'Y1' OLD, NULL NEW, TO_DATE('2019-03-01', 'yyyy-mm-dd') FROM DUAL
  10. UNION ALL
  11. SELECT 2 ID, NULL OLD, 'Z2' NEW, TO_DATE('2019-02-02', 'yyyy-mm-dd') FROM DUAL
  12. UNION ALL
  13. 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