PL/SQL is an extension of the SQL language that combines the data manipulation power of SQL with the processing power of procedural language to create super-powerful SQL queries.
This competency area includes the usage of Exception Handling, Procedures, and Functions, as well as a good understanding of Type and Package.
- Exception Handling - This competency includes handling exceptions, avoiding errors, and writing efficient PL/SQL blocks.
- Procedure and Function - Creation of stored functions and procedures while writing queries.
- Type and Package - This competency includes the design of packages and types.