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 Oracle 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

 
Copyright © 1999-2024 SS64.com
Some rights reserved