By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| ROW_ | CODE | DATE_ | PERIOD |
|---|---|---|---|
| 1 | Start_period | 01-JAN-19 | 1 |
| 2 | End_period | 15-JAN-19 | 1 |
| 3 | Random_code1 | 15-FEB-19 | 1 |
| 4 | Random_code2 | 28-FEB-19 | 1 |
| 5 | End_period | 31-MAR-19 | 1 |
| 6 | Start_period | 31-MAY-19 | 2 |
| 7 | End_period | 11-JUN-19 | 2 |
| 8 | End_period | 28-AUG-19 | 2 |