About this document
PL/SQL Blocks for Database Queries by Maria Muscas is a document available to read on EtoBox.
The document contains a series of exercises using PL/SQL cursors. It asks the user to write PL/SQL blocks that: 1) Display countries in South America with non-null holidays. 2) Display the top 5 departments by employee count. 3) Modify the previous block to handle any number of rows instead of a hardcoded number. 4) Convert a cursor loop to a cursor FOR loop. 5) Pass a parameter to a cursor to filter by region. 6) Display departments and their employees in a nested cursor structure.
- Author
- Maria Muscas
- Language
- EN