Collections:
Drop a Stored Procedure in Oracle
How To Drop a Stored Procedure in Oracle?
✍: FYIcenter.com
If there is an existing stored procedure and you don't want it any more, you can remove it from the database by using the DROP PROCEDURE statement as shown in the following script example:
SQL> CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welcome to FYICenter!'); 4 END; 5 / Procedure created. SQL> DROP PROCEDURE Greeting; Procedure dropped.
⇒ Pass Parameters to Procedures in Oracle
⇐ Execute a Stored Procedure in Oracle
2018-11-11, 3169🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...