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

This preview shows page 1 - 2 out of 3 pages.

The preview shows page 1 - 2 out of 3 pages.
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.
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

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
JORGE OMAR JASSO LUNA
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture