You can now finally drop the dreaded "FROM DUAL" clause starting Oracle 23c.
(I know this is an old question but it was ranked high when I googled "from dual" so I figured I'd do a service for those like me.)