Drop a procedure - Oracle

If you no longer want a procedure in your database, you can remove it.

The SQL statement DROP PROCEDURE removes a procedure from a database.

Please use caution, because the effect is permanent!

DROP PROCEDURE is classified in SQL as a Data Definition Language (DDL) statement. Other examples of SQL statements in this category include CREATE, ALTER, RENAME and TRUNCATE.

Oracle issues an automatic COMMIT after a DDL statement is executed. Therefore, no rollback is possible after executing a DDL statement.

You need the CREATE PROCEDURE system privilege to create a procedure in your own schema.

At the SQL*Plus command prompt, issue the DROP PROCEDURE SQL statement to remove your procedure called skeleton:

SQL> DROP PROCEDURE skeleton;

SQL*Plus assures us the procedure has been removed:

Procedure dropped.

Now let's sum up it all up.