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

Output

FUNCTION GET_CURRENT_MONTH compiled

Now Drop the function.

Output

function GET_CURRENT_MONTH dropped.
References
  1. DROP Function :- Oracle official docs
It's good to share...Share on FacebookTweet about this on TwitterShare on LinkedInPin on PinterestShare on Google+Email this to someone

Leave a Reply

Your email address will not be published. Required fields are marked *