Oracle Database 23ai New Features and Enhancements
Jan 29, 2024 · 15 min read · 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...
Join discussion