SQL


What is PL/SQL


  • Provides block structure, easy to maintain, defines structure 
  • Provides procedural constructs such as
    • Variable, Constant & Type
    • Control structures such as loop
    • Reusable program that is written once and executed multiple times.


This is incorporating of programming logic with traditional SQL statements like loops and other control statements.

Advantage :

  • Integration of procedural construct with SQL
  • Improve performance
  • Modularization
  • Integrate Oracle tools like ( Oracle Forms , Report etc...)
  • Exception Handeling


How PL/SQL Engine works.


Block consist of multiple statements, each statements is parsed at a time each statement is checked for each type, if statement is SQL type its parsed by "SQL Engine" else by "PL/SQL Engine" so there is engine switch ever time we have different type of statement.

Note :
  • Code should be designed so we have minimum engine switch.
  • This is a part of optimization technique this can be achieved by below techniques
    • BULK COLLECT
    • BULK BIND

No comments:

Post a Comment