CoderZone.org

Category: >> Oracle PL/SQL >> FUNCTIONS: drop Bookmark and Share

<< lastnext >>

Snippet Name: FUNCTIONS: drop

Description: To drop a function, the function must be in your own schema or you must have the DROP ANY PROCEDURE system privilege.

You may specify the schema containing the function. If you omit the schema name then the database assumes the function is in your own schema.

The database invalidates any local objects that depend on, or call, the dropped function. If you subsequently reference one of these objects, then the database tries to recompile the object and returns an error if you have not re-created the dropped function.

If any statistics types are associated with the function, then the database disassociates the statistics types with the FORCE option and drops any user-defined statistics collected with the statistics type.

Also see:
» Create a drop down menu from an ar...
» Drag And Drop Example
» DHTML Combo Box Dropdown
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» TABLESPACE: Dropping Tablespaces
» INDEXES: DROP index
» USER - drop user
» USERS: Drop users
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» SUBST and INSTR together
» INSTR (InString)
» SUBSTR (SubString)
» String Functions: REVERSE
» String Functions: LENGTH

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 13th, 2009

DROP a FUNCTION DROP FUNCTION <function_name>; 
 
DROP FUNCTION calculate_sales_ratio; 
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 9