SELECT 1, rather than SELECT 1 FROM DUAL

User_1871

It would be great if Oracle could remove the need for DUAL and let you just do select 1 rather than select 1 from dual.

That would help simplify queries.

mtefft

I doubt that it would simplify queries.

SQL Server, Postgres and others provide this "shortcut". But the original premise of SQL was that rows come from tables. They do not appear from nothing.

User_1871

I like the Postgres, MySQL and sql server functionality. To me, "FROM DUAL" seems unnecessary.

Sven W.

Comming in 23c