By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ORA-30076: invalid extract field for extract source
| EXTRACT(DAYFROMTO_DATE('02-10-2019','DD-MM-YYYY'))-EXTRACT(DAYFROMTO_DATE('01-10-2019','DD-MM-YYYY')) |
|---|
| 1 |