So what's this business with Oracle allowing programmers to put programs in databases? That's right. They're called Oracle stored procedures, and they're quite useful. Mooh the Cow walks you through writing, creating, debugging, and deleting a procedure.
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:
/ 879 
