Create the Employee/Department database (script provided below). Write and run a PL/SQL block which produces a report
Question:
Create the Employee/Department database (script provided below).
Write and run a PL/SQL block which produces a report listing world regions, countries in those regions, the population and the currency info for each country.
You will need two cursors: an outer loop cursor which fetches and displays rows from the REGIONS table, and an inner loop cursor which fetches and displays rows from the COUNTRIES table for countries in that region, passing the region_id as a parameter. You also need to use the CURRENCIES table to retrieve the currency information for each country in this cursor. Include your first and last name in the title line of the results
Restrict your regions to those in the Africa (region_name like '%Africa%'). Order your output by region_name, and by country_name within each region. Your output should look something like this (only the first few records are shown):
Expert Answer:
Creating and running a PLSQL block to produce a report as described involves multiple SQL statements ... View the full answer
