PROCEDURES

PROCEDURE:

        In PL/SQL procedure contains two parts:
                       1)Declaration of procedure
                       2)Body of procedure

•  Declaration of procedure starts with a keyword called CREATE OR REPLACE and ends with  last variable parameter.

•  Body of procedure starts with a keyword called IS or AS  and ends with END statement.

Syntax to write a Procedure:

    CREATE or REPLACE Procedure <Procedure name>
    (List of Parameters)
    IS/AS
    Variable Declaration;
    BEGIN
    Statement 1;
    .
    .
    Statement 2;
    END;