SELECT without FROM Clause – Oracle database 23c New Feature

SQL Without FROM Clause

In 23c we can run select expression-only queries without a FROM clause.

Examples

Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

SQL>  SELECT 'Hello!World' MESSAGE;

MESSAGE
-----------
Hello!World

SQL>  select 1+1 Total;
     TOTAL
----------
         2

SQL> select sysdate;
SYSDATE
---------
01-JUL-23

SQL> select systimestamp;
SYSTIMESTAMP
------------------------------------
01-JUL-23 01.37.14.161630 PM -04:00

SQL>

Leave a Comment