Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Drop a Stored Procedure
How To Drop a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: 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.
2007-04-26, 6353👍, 0💬
Popular Posts:
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...
How To Control Padding Spaces within a Table Cell? - XHTML 1.0 Tutorials - Understanding Tables and ...
How To Create an Add-to-Bloglines Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...
How To Merge Cells in a Column? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells If you ...
Can we have shared events ? Yes, you can have shared event’s note only shared methods can raise shar...