By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 |
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | 0 |
1 rows affected
1 rows affected
1 rows affected
| ID | DT |
|---|---|
| 1 | 2021-SEP-18 13:23:33 |
| 2 | 2021-SEP-18 14:23:33 |
| 2 | 2021-SEP-18 14:23:33 |
| TRUNC(DT) | COUNT(*) |
|---|---|
| 2021-SEP-18 00:00:00 | 3 |
| TRUNC(DT,'HH') | COUNT(*) |
|---|---|
| 2021-SEP-18 13:00:00 | 1 |
| 2021-SEP-18 14:00:00 | 2 |
| ID | DT | SLAB |
|---|---|---|
| 1 | 2021-SEP-18 13:23:33 | 01 |
| 2 | 2021-SEP-18 14:23:33 | 02 |
| 2 | 2021-SEP-18 14:23:33 | 02 |
| N | SLAB |
|---|---|
| 2 | 02 |
| 1 | 01 |