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 Create a Stored Procedure
How To Create a Stored Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example script below creates a stored procedure:
SQL> CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welcome to FYICenter!'); 4 END; 5 / Procedure created.
2007-04-26, 4939👍, 0💬
Popular Posts:
Can Two Forms Be Nested? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields Can two forms ...
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...
What's wrong with this initialization? char *p = malloc(10); My compiler is complaining about an ``i...
What Tools to Use to View HTML Documents? The basic tool you need to view HTML documents is any Web ...
How do we host a WCF service in IIS? Note: - The best to know how to host a WCF in IIS is by doing a...