CREATE OR REPLACE
If the component exists, replaces it; if it does not exist, creates it. Every CREATE
statement has a corresponding CREATE OR REPLACE
statement. The syntax is the same, just add OR REPLACE
after CREATE
. For an example, see ALTER and RECOMPILE.