zlacker

    SELECT 1+2;

FROM clauses aren't required, and using multiple tables in FROM doesn't seem to work out too well when that syntax is listed first.

>>akira2+(OP)
WITH clauses are optional and appear before SELECT. No reason why the FROM clause couldn't behave the same

>>yen223+2a
Isn't that strictly for CTEs? In which case, you are SELECTing from the CTE.

>>akira2+(OP)
Beginning with Oracle Database Release 23 [released May 2, 2024], it is now optional to select expressions using the FROM DUAL clause.

>>akira2+(OP)
Doesn’t change anything, you can still have the select at the end, and optional from and joins at the beginning. In your example, the select could be at the end, it’s just that there’s nothing before.