23ai New Feature - UPDATE RETURN Clause Enhancements
(Doc ID 3003012.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version Beta 23ai and laterOracle Database - Standard Edition - Version Beta 23ai and later
Information in this document applies to any platform.
Goal
Oracle database 23ai introduced the UPDATE RETURN Clause Enhancements.
The RETURNING INTO clause for INSERT, UPDATE, and DELETE statements are enhanced
to report old and new values affected by the respective statement.
This document has a use case example of the new 23ai feature "UPDATE RETURN Clause Enhancements".
For more details, see document:
Oracle Database New Features
SQL UPDATE RETURN Clause Enhancements
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-9F2A7E70-743E-40C9-A021-EB8D24E6597F
SQL UPDATE RETURN Clause Enhancements
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-9F2A7E70-743E-40C9-A021-EB8D24E6597F
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |