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...