How do I use CREATE OR REPLACE?

This works on functions, procedures, packages, types, synonyms, trigger and views.

Update:

After updating the post for the third time, I’ll reformulate this:

This does not work on tables 🙂

And yes, there is documentation on this syntax, and there are no REPLACE option for CREATE TABLE.