PL/SQL is used in Oracle as a procedural language extension to SQL. Its purpose is to combine both database and procedural programming language. It combines SQL’s data manipulation power with procedural language’s processing power in order to create powerful SQL queries. It instructs the compiler what it needs to do via SQL and how a task needs to be done through the procedural way. It gives control to the coders and programmers with conditions, loops, and concepts of object-oriented programming.
PL/SQL consists of a number of units including:
- Function
- Package Specification
- Procedure
- Trigger
- Anonymous Block
- Library
- Package Body
- Type
- Type Body
If you wish to make a career in PL/SQL then you must go through PL/SQL Interview Questions.
Also, check out this video tutorial on PL/SQL:
Back