Oracle 23c #dual table #quicktip

We’ve been using the dual table to return information on functions for longer than I care to think about. Now, in 23c you don’t need to include “from dual” in your code.

-- cold way
Selecting an expression without FROM DUAL
SQL> select sysdate, user from dual;

SYSDATE      USER
____________ ___________
19-MAY-23    RLOCKARD

-- 23c new way.
Selecting an expression without FROM DUAL
SQL> select sysdate, user;

SYSDATE      USER
____________ ___________
19-MAY-23    RLOCKARD