4 ms·
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.
by akira2501 2y ago
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.
- yen223 2y agoWITH clauses are optional and appear before SELECT. No reason why the FROM clause couldn't behave the same
- akira2501 2y agoIsn't that strictly for CTEs? In which case, you are SELECTing from the CTE.
- ElectricalUnion 2y agoBeginning with Oracle Database Release 23 [released May 2, 2024], it is now optional to select expressions using the FROM DUAL clause.
- thiht 2y agoDoesn’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.