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, 5108👍, 0💬
Popular Posts:
In below sample code if we create a object of class2 which constructor will fire first? Public Class...
What is synchronization and why is it important? With respect to multithreading, synchronization is ...
Enable ASP.NET polling using “web.config” file Now that all our database side is configured in order...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
What are the different storage classes in C? C has three types of storage: automatic, static and all...