PL/SQL

PL/SQL

1. Engine

   • SQL Query
     • Oracle Process

2. Advantages

   • Block Structure
   • Error handling
   • Performance
     • PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.

3. Stored

   • Client
   • Database

4. 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