Oracle PL/SQL – DROP FUNCTION Statement
This article will help you to understand “Oracle PL/SQL – DROP FUNCTION Statement” with example and description.
The
Example
1. DROP function example
Here first we will create function get_current_month. Then we will DROP it using
Code
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
--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
Now Drop the function.
0 1 2 |
DROP FUNCTION GET_CURRENT_MONTH; |
Output