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, 3014🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...