Collections:
Drop a Stored Function in Oracle
How To Drop a Stored Function in Oracle?
✍: 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.
2018-10-26, 985👍, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...