PL/SQL

Intermediate

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.

Key Competencies: 

  1. Exception Handling - This competency includes handling exceptions, avoiding errors, and writing efficient PL/SQL blocks.
  2. Procedure and Function - Creation of stored functions and procedures while writing queries.
  3. Type and Package - This competency includes the design of packages and types.