Database Programming with PL/SQL6-2:Using Explicit Cursor AttributesPractice ActivitiesVocabularyIdentify the vocabulary word for each definition below:Fetch_StatusReturns the status of the cursor%ROWCOUNTAn attribute that processes an exact number of rows or counts thenumber of rows fetched in a loop%NOTFOUNDAn attribute used to determine whether the most recent FETCHstatement successfully returned a rowTry It/Solve It1.In your own words, explain the advantage of using %ROWTYPE to declare a record structurebased on a cursor declaration.
Get answer to your question and much more
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