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, 5710👍, 0💬
Popular Posts:
How To Get the Last ID Assigned by MySQL? - MySQL FAQs - Managing Tables and Running Queries with PH...
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
What Does a HTML Document Look Like? A HTML document is a normal text file with predefined tags mixe...
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she o...