PL/SQL

1. Oracle Process

Annotations:

• PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.

1. Procedures
2. Functions

1. Declaration Section
   1. Variables
      1. Scope
      2. Types
         1. Scalar
            1. Number
            2. Character
            3. DateTime
         2. Composite
         3. Reference
2. Execution Section
   1. Conditions Statements
   2. Iterative Statements
   3. Cursors
      1. Implicit
      2. Explicit
3. Exception Section