PL/SQL is an extension of 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 understanding of basic concepts like Blocks, Variable Declaration, and Cursor.
- Blocks - Ability to write the beginning end blocks and convert SQL into PL/SQL.
- Variable Declaration - Ability to declare variables in a PL/SQL and usage of %type and %rowtype.
- Cursor - This competency includes knowledge of writing cursor, using loops, and working on a set of data.