Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Drop a Stored Function
How To Drop a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
If there is an existing stored function and you don't want it any more, you can remove it from the database by using the DROP FUNCTION statement as shown in the following script example:
SQL> CREATE OR REPLACE FUNCTION GET_SITE 2 RETURN VARCHAR2 AS 3 BEGIN 4 RETURN 'FYICentere.com'; 5 END; 6 / Function created. SQL> DROP FUNCTION GET_SITE; Function dropped.
2007-04-25, 5092👍, 0💬
Popular Posts:
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
What is SMC approach of estimation?
What is Shell scripting A shell script is a script written for the shell, or command line interprete...
How Large Can a Single Cookie Be? - PHP Script Tips - Understanding and Managing Cookies How large c...