Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How To Create a Stored Procedure in Oracle?

Oracle Database Interview Question
Oracle Database Interview Question

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.


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Define an Anonymous Procedure with Variables?How To Execute a Stored Procedure in Oracle?