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, 3088🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...