Database Programming with PL/SQL
Indexing Tables of Records
Yashub Armando Guzman Espinoza
Identify the vocabulary word for each definition below.
A set of occurrences of the same kind of data
INDEX BY table
A collection which is based on a single field or column; for example,
on the last_name column of EMPLOYEES
INDEX BY table of
A collection which is based on a composite record type; for example,
on the whole DEPARTMENTS row
Try It / Solve It
1. PL/SQL collections:
A. In your own words, describe what a PL/SQL collection is.
B. Which of the following are collections and which are not?
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their