Search notes:

Oracle SQL: DROP

See also

The SQL*Plus script drop_if_exists.sql that drops an object if it exists.
It makes up for the missing drop … if exists SQL statement in Oracle versions prior to 23c.

Index