PLSQL_6_2_PracticeE.docx - www.oracle.com/academy Database...

Database Programming with PL/SQL
6-2:
Using Explicit Cursor Attributes
Practice Activities
Vocabulary
Identify the vocabulary word for each definition below:
Fetch_Status
Returns the status of the cursor
%ROWCOUNT
An attribute that processes an exact number of rows or counts the
number of rows fetched in a loop
%NOTFOUND
An attribute used to determine whether the most recent FETCH
statement successfully returned a row
Try It/Solve It
1. In your own words, explain the advantage of using %ROWTYPE to declare a record structure
based on a cursor declaration.
2. Write a PL/SQL block to read through rows in the countries table for all countries in region 5
(South America region). For each selected country, display the country_name,
national_holiday_date, and national_holiday_name. Use a record structure to hold all the columns