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.
- Bulk Collect and FORALL - Usage of Bulk Collect and FORALL ability to handle bulk data in the databases.
- Save Exception - This competency includes handling exceptions in bulk data and preventing interruption of PL/SQL.
- Pipelined Functions and SYS_REFCURSOR - This competency includes handling advanced PL/SQL to handle functions in a table format.