add remove language chart show hidden hide
db<>fiddle
donate feedback about
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