InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Create A Stored Procedure? |
|
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 BEGIN DBMS_OUTPUT.PUT_LINE('Welcome to WISDOM!'); END; /Procedure created. 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: Procedure created. |
|