DROP FUNCTION

You can use the DROP FUNCTION statement to drop an independent function from the database.

Notice

If the function to be dropped is part of a program package, do not use this statement to drop it. Instead, use the DROP PACKAGE statement to drop the entire program package, or use a CREATE PACKAGE statement with an OR REPLACE clause to redefine a program package without this function.

Prerequisites

The function must be located in your own schema, or you must have the ALTER ANY PROCEDURE system privilege.

Syntax

Syntax of drop_function:

DROP FUNCTION [ schema. ] function_name ;

Semantics

Examples

Drop the function named sys.get_salary_by_dept.

DROP FUNCTION sys.get_salary_by_dept;