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

Advanced

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 usage of Bulk Collect, FORALL, Save Exception, Pipeline Function, and SYS_REFCURSOR.  

Key Competencies: 

  1. Bulk Collect and FORALL - Usage of Bulk Collect and FORALL ability to handle bulk data in the databases.
  2. Save Exception - This competency includes handling exceptions in bulk data and preventing interruption of PL/SQL.
  3. Pipelined Functions and SYS_REFCURSOR - This competency includes handling advanced PL/SQL to handle functions in a table format.