Deleting a Function v12
A function can be deleted from the database using the DROP FUNCTION command.
DROP FUNCTION [ IF EXISTS ] <name> [ (<parameters>) ]
[ CASCADE | RESTRICT ];Where name is the name of the function to be dropped.
Note
The specification of the parameter list is required in Advanced Server under certain circumstances such as if this is an overloaded function. Oracle requires that the parameter list always be omitted.
Usage of
IF EXISTS, CASCADE, orRESTRICTis not compatible with Oracle databases. See theDROP FUNCTIONcommand in the Database Compatibility for Oracle Developers SQL Guide for information on these options.
The previously created function is dropped in this example:
DROP FUNCTION simple_function;