PL/SQL Drop Procedure
In PL/SQL a standalone procedure can be deleted with the DROP PROCEDURE statement.
PL/SQL Drop Procedure Syntax
To delete an existing procedure, use the following syntax:
Syntax
DROP PROCEDURE procedure_name;
Where:
procedure_name: The name of the procedure.
PL/SQL Drop Procedure example
The following PL/SQL show how to delete existing procedure:
Example
DROP PROCEDURE CreateUser;