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, 3016🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...