As of 23c, Oracle supports SELECT SYSDATE (or whatever other system function you want to use), without FROM DUAL, like most other RDBMS.