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.