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