PL/SQL Drop Function

In PL/SQL a standalone FUNCTION can be deleted with the DROP FUNCTION statement.

PL/SQL Drop Function Syntax

To delete an existing procedure, use the following syntax:

DROP FUNCTION function_name;

Where:

function_name: The name of the function to be deleted.

The following PL/SQL show how to delete existing function:

DROP FUNCTION TotalUsers;