Oracle DBA ++

UPDATE RETURN Clause Enhancements - A new feature in Oracle 23ai

UPDATE RETURN Clause Enhancements - A new feature in 23ai

Rupesh Ghubade December 28, 2024

Starting from Oracle 23ai , Oracle has added new enhancements for INSERT , UPDATE , and DELETE statements. This help…

IF [NOT] EXISTS Syntax Support - A new feature in Oracle 23ai

Rupesh Ghubade November 22, 2024

Starting from Oracle 23ai , Oracle Database now supports IF EXISTS or IF NOT EXISTS clauses in DDL statements. This …

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…