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.
⇒ Call a Stored Functoin with Parameters in Oracle
⇐ Call a Stored Function in Oracle
2018-10-26, 2416🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...