By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| PERSON_ID | PREV_START_DT | START_DT | LOC_OLD | LOC_NEW | ORG_OLD | ORG_NEW |
|---|---|---|---|---|---|---|
| 1 | 01-JAN-19 | 21-JAN-19 | 123 | 223 | - | - |
| 2 | 01-JAN-19 | 04-JUL-19 | 123 | 111 | 789 | 890 |