Home Oracle Commands

DROP FUNCTION

Drop a stand-alone function:

Syntax:

   DROP FUNCTION [schema.]function

To remove a function that is part of a package, either drop the entire package using DROP PACKAGE or redefine the package using CREATE OR REPLACE PACKAGE.


"Do you feel you've learnt by your mistakes here?

I think I have, yes, and I think I can probably repeat them almost
perfectly. I know my mistakes inside out" - Peter Cook and Dudley Moore

Related Commands:

FUNCTION - CREATE FUNCTION
FUNCTION - ALTER FUNCTION
PACKAGE - CREATE PACKAGE
PACKAGE - ALTER PACKAGE
PACKAGE - DROP PACKAGE

Related Views:

 CODE_PIECES 
 CODE_SIZE 
 DBA_SOURCE      ALL_SOURCE      USER_SOURCE

Equivalent SQL Server command:

DROP FUNCTION



Back to the Top

Simon Sheppard
SS64.com