Skip to main content

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.