Drop a stand-alone function:
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
FUNCTION - CREATE FUNCTION
FUNCTION - ALTER FUNCTION
PACKAGE - CREATE PACKAGE
PACKAGE - ALTER PACKAGE
PACKAGE - DROP PACKAGE
CODE_PIECES CODE_SIZE DBA_SOURCE ALL_SOURCE USER_SOURCE
© Copyright SS64.com 1999-2013
Some rights reserved