23ai New Feature - DEFAULT ON NULL for UPDATE Statements
(Doc ID 3002987.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Standard Edition - Version Beta 23ai and laterOracle Database - Enterprise Edition - Version Beta 23ai and later
Information in this document applies to any platform.
Goal
Oracle database 23ai introduced the DEFAULT ON NULL for UPDATE Statements.
You can define columns as DEFAULT ON NULL for update operations, which was previously only possible for insert operations.
This document has a use case example of the new 23ai feature "DEFAULT ON NULL for UPDATE Statements".
For more details, see document:
Oracle Database New Features
DEFAULT ON NULL for UPDATE Statements
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-2DCF6133-7522-49AF-BA06-9E01DE4E5D98
DEFAULT ON NULL for UPDATE Statements
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-2DCF6133-7522-49AF-BA06-9E01DE4E5D98
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 |