Oracle PL/SQL - DROP FUNCTION Statement

Oracle PL/SQL – DROP FUNCTION Statement

This article will help you to understand “Oracle PL/SQL – DROP FUNCTION Statement” with example and description.

The DROP FUNCTION statement drops a standalone stored function from the database.

Example

1. DROP function example

Here first we will create function get_current_month. Then we will DROP it using DROP FUNCTION statement.

Code


--Creating function

CREATE OR REPLACE FUNCTION get_current_month
RETURN VARCHAR2 IS
curr_month VARCHAR2(10);

BEGIN
  
    SELECT to_char(sysdate, 'MONTH') INTO curr_month FROM dual;
    
    return curr_month;

END get_current_month;
/

--Creating function

CREATE OR REPLACE FUNCTION get_current_month

RETURN VARCHAR2 IS

curr_month VARCHAR2(10);

BEGIN

SELECT to_char(sysdate, 'MONTH') INTO curr_month FROM dual;

return curr_month;

END get_current_month;

Output

FUNCTION GET_CURRENT_MONTH compiled

Now Drop the function.


DROP FUNCTION GET_CURRENT_MONTH;

DROP FUNCTION GET_CURRENT_MONTH;

Output

function GET_CURRENT_MONTH dropped.

References

DROP Function :- Oracle official docs

Scala Functions
Method Reference in Java 8
LeetCode - Valid Perfect Square
Basics of Scala
How to check if two Trees are Identical or Not?
LeetCode - Move Zeroes - 30Days Challenge

Facebook

Twitter