Oracle Database 23ai New Features and Enhancements
SELECT without FROM DUAL
Oracle Database 23ai, you can use SELECT without specifying dual table.
SELECT sysdate, 'Hello World' ; output : 30-JAN-24 Hello World
Use column alias in GROUP BY and HAVING
You can use column aliases and position numbers in...
