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.

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 




Back to the Top

Simon Sheppard
SS64.com