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

Oracle PL/SQL - ALTER FUNCTION Statement
DROP Trigger
Scala Functions
Oracle PL/SQL - Create Function Example
Useful Commands in JShell - Java 9
Method Reference in Java 8

Facebook

Twitter