New Features 23c: Table with EXIST or NOT EXIST Clause

As new features within Oracle Database 23c, we can avoid “ORA-00955” table already exists while creating a table, and we can avoid “ORA-00942” table does not exists while dropping a table.

Create with “IF NOT EXISTS”

Drop with “IF EXISTS”

Enjoy this new feature with 23c.

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply