Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: FUNCTIONS: drop Jump to:  
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 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

DROP a FUNCTION DROP FUNCTION <function_name>; 
 
DROP FUNCTION calculate_sales_ratio; 
 


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 255 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?