PL/SQL

1. Oracle Process

Anotações:

• 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