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 array ...
» Drag And Drop Example
» DHTML Combo Box Dropdown
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» 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)

Language:
Highlight Mode: PLSQL
Last Modified: March 13th, 2009