Dropping Procedures and Functions
Creating and Using Standalone Procedures and Functions
4-8 Oracle Database 2 Day Developer's Guide
Disconnecting from the database hr_conn.
Dropping Procedures and Functions
You can delete a procedure or function from the database using either the Connection
Navigator, or the SQL
DROP
statement.
To drop a procedure:
You will drop the procedure
ADD_EVALUATION
.
1.
In the Connections navigator hierarchy, right-click the
ADD_EVALUATION
function.
Select Drop.
2.
In the Drop window, click Apply.
See Also:
Oracle Database SQL Language Reference for information on the
system privileges users need to run procedures and functions
Oracle Database PL/SQL Language Reference for information on how
to use the
EXECUTE IMMEDIATE
statement for dynamic SQL
