What is the difference in CREATE or [REPLACE] Procedure and to drop a procedure and create it again? What does REPLACE do, Does it drop the existing one and create the new one with same name?

Abhijit Musale

• Mar 23rd, 2015

PLSQL objects and views can be replaced if pre-exists using REPLACE keyword.

souvik

• Nov 16th, 2014

If you drop the procedure, then all the privileges are gone which you will have to give again while creating the program. But CREATE OR [REPLACE] command will keep the privileges intact.

Answer Question  Select Best Answer