Mind map

PL/SQL

lud.ska PL/SQL Portuguese

Map content

PL/SQL

Engine
- SQL Query
  - Oracle Process
Advantages
- Block Structure
- Error handling
- Performance
  - PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.
Stored
- Client
- Database
Block
- Anonymous
- Named
  - Procedures
  - Functions
- Structure
  - Declaration Section
    - Variables
      - Scope
      - Types
        Scalar
        Number
        Character
        DateTime
        Composite
        Reference
  - Execution Section
    - Conditions Statements
    - Iterative Statements
    - Cursors
      - Implicit
      - Explicit
  - Exception Section