My Oracle Support Banner

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 later
Oracle 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

 

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.