By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_SUBSTR(WORKING_HOURS,'(.*?)(;|-|$)',1,(2*LEVEL-1),NULL,1) | REGEXP_SUBSTR(WORKING_HOURS,'(.*?)(;|-|$)',1,2*LEVEL,NULL,1) |
|---|---|
| 08:00:00 | 11:59:00 |
| 13:00:00 | 16:59:00 |
| TO_CHAR(DATE'2000-01-01'+((LEVEL-1)/48),'HH24:MI":00"') |
|---|
| 00:00:00 |
| 00:30:00 |
| 01:00:00 |
| 01:30:00 |
| 02:00:00 |
| 02:30:00 |
| 03:00:00 |
| 03:30:00 |
| 04:00:00 |
| 04:30:00 |
| 05:00:00 |
| 05:30:00 |
| 06:00:00 |
| 06:30:00 |
| 07:00:00 |
| 07:30:00 |
| 08:00:00 |
| 08:30:00 |
| 09:00:00 |
| 09:30:00 |
| 10:00:00 |
| 10:30:00 |
| 11:00:00 |
| 11:30:00 |
| 12:00:00 |
| 12:30:00 |
| 13:00:00 |
| 13:30:00 |
| 14:00:00 |
| 14:30:00 |
| 15:00:00 |
| 15:30:00 |
| 16:00:00 |
| 16:30:00 |
| 17:00:00 |
| 17:30:00 |
| 18:00:00 |
| 18:30:00 |
| 19:00:00 |
| 19:30:00 |
| 20:00:00 |
| 20:30:00 |
| 21:00:00 |
| 21:30:00 |
| 22:00:00 |
| 22:30:00 |
| 23:00:00 |
| 23:30:00 |
| BLOCK_FROM | FLAG |
|---|---|
| 00:00:00 | 0 |
| 00:30:00 | 0 |
| 01:00:00 | 0 |
| 01:30:00 | 0 |
| 02:00:00 | 0 |
| 02:30:00 | 0 |
| 03:00:00 | 0 |
| 03:30:00 | 0 |
| 04:00:00 | 0 |
| 04:30:00 | 0 |
| 05:00:00 | 0 |
| 05:30:00 | 0 |
| 06:00:00 | 0 |
| 06:30:00 | 0 |
| 07:00:00 | 0 |
| 07:30:00 | 0 |
| 08:00:00 | 1 |
| 08:30:00 | 1 |
| 09:00:00 | 1 |
| 09:30:00 | 1 |
| 10:00:00 | 1 |
| 10:30:00 | 1 |
| 11:00:00 | 1 |
| 11:30:00 | 1 |
| 12:00:00 | 0 |
| 12:30:00 | 0 |
| 13:00:00 | 1 |
| 13:30:00 | 1 |
| 14:00:00 | 1 |
| 14:30:00 | 1 |
| 15:00:00 | 1 |
| 15:30:00 | 1 |
| 16:00:00 | 1 |
| 16:30:00 | 1 |
| 17:00:00 | 0 |
| 17:30:00 | 0 |
| 18:00:00 | 0 |
| 18:30:00 | 0 |
| 19:00:00 | 0 |
| 19:30:00 | 0 |
| 20:00:00 | 0 |
| 20:30:00 | 0 |
| 21:00:00 | 0 |
| 21:30:00 | 0 |
| 22:00:00 | 0 |
| 22:30:00 | 0 |
| 23:00:00 | 0 |
| 23:30:00 | 0 |
| RESULT |
|---|
| 000000000000000011111111001111111100000000000000 |