Basic Oracle Concepts and Programming Question:
How To Create a Stored Procedure in Oracle?
Answer:
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 globalguideline!');
4 END;
5 /
Procedure created.
SQL> CREATE PROCEDURE Greeting AS
2 BEGIN
3 DBMS_OUTPUT.PUT_LINE('Welcome to globalguideline!');
4 END;
5 /
Procedure created.
| Previous Question | Next Question |
| How To Define an Anonymous Procedure with Variables? | How To Execute a Stored Procedure in Oracle? |