We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Skills Directory
  2. PL/SQL

PL/SQL

Basic

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.

Key Competencies: 

  1. Blocks - Ability to write the beginning end blocks and convert SQL into PL/SQL.
  2. Variable Declaration - Ability to declare variables in a PL/SQL and usage of %type and %rowtype.
  3. Cursor - This competency includes knowledge of writing cursor, using loops, and working on a set of data.