Oracle DBA ++

SELECT Without FROM Clause - A new feature in Oracle 23ai

Rupesh Ghubade November 10, 2024

Starting from Oracle 23ai , you can now query the DUAL table without FROM clause. Let us demontsrate the same with s…

GROUP BY Column Alias- A new feature in Oracle 23ai

Rupesh Ghubade November 08, 2024

Starting from Oracle 23ai , you can specify column aliases or positions in GROUP BY clause. You can also specif…

DEFAULT ON NULL for update - A new feature in Oracle 23ai

Rupesh Ghubade November 06, 2024

Starting from Oracle 23ai , you can define columns as DEFAULT ON NULL for update operations, which was previously on…

Oracle Database 23ai - Latest Long Term Release