Chapter 7. Nested Tables
In addition to simply renaming PL/SQL tables to index-by tables in Oracle8, Oracle introduced two new collection datatypes: nested arrays and variable arrays. While conceptually similar to index-by tables, the two new collection types are usable in SQL statements (for example, you can insert multiple rows of a collection into a table via Oracle 8i Release 8.1’s bulk collection operators) and may be stored as columns in a database table. This chapter tests your understanding of nested tables, the first of the new collection types. Specifically, it examines your ability to create a nested table type, store the array in a “store table,” add and delete elements, and traverse each element.
Beginner
7-1. | What SQL syntax is introduced in Oracle8 to create nested table types? |
7-2. | True or false?
|
7-3. | Fixit Later is the System Architect at Simplistic Procurement Systems, and he has executed the following DDL to create a new system: SQL> CREATE TYPE detail_t AS OBJECT ( detail_no PLS_INTEGER, 2 detail_desc VARCHAR2(30), ... |
Get Oracle PL/SQL Programming: A Developer's Workbook 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.