23ai New Feature - IF [NOT] EXISTS Syntax
(Doc ID 3002402.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 23.4 and laterOracle Database - Standard Edition - Version 23.4 and later
Information in this document applies to any platform.
Goal
Oracle Database supports IF EXISTS or IF NOT EXISTS in DDL statements that create, modify, and delete objects from 23ai.
This allows to control the occurrence of an error when a particular object exists/does not exist.
You can expect this syntax to simplify error handling in scripts and applications.
This document has a use case example of the new 23ai feature "IF [NOT] EXISTS Syntax".
For more details, see document:
Oracle Database Release 23
Oracle Database New Features
2 Application Development
IF [NOT] EXISTS Syntax Support
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-BCB12451-7F41-446D-A298-A105A6EF0632
Oracle Database New Features
2 Application Development
IF [NOT] EXISTS Syntax Support
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-BCB12451-7F41-446D-A298-A105A6EF0632
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 |