Chapter 8, Problem 5CAT

Program Plan Intro

Stored procedures:

• When user expect to running a particular query often, user can expand total performance by saving the query in a file called a stored procedure.
  • The stored procedure is located on the server.
  • The DBMS compiles the stored procedure and creates an execution plan, which is the well-organized method of finding the results.
• It is a procedure which contains collection of procedural and SQL statements.

Syntax for stored procedure:

CREATE FUNCTION fun_name(argument IN data-type)RETRUN data-type[IS]

BEGIN

    PL/SQL statements;

    Return (value or expression);

END;