Chapter 19 Test Your Thinking

In this chapter, you learned about various types of records, nested records, and collections of records. Here are some projects that will help you test the depth of your understanding.

1) Create the following script. Create an index-by table with the element type of a user-defined record. This record should contain first name, last name, and the total number of courses that a particular instructor teaches. Display the records of the index-by table on the screen.
2 Modify the script created in project (1). Instead of using an index-by table, use a nested table.
3) Modify the script created in project (2). Instead of using a nested table, use a varray.
4) Create the following script. Create a user-defined record with ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.