Chapter 8. Variable Arrays
Variable arrays (VARRAYs) are the third collection type introduced in Oracle8. Unlike index-by tables or nested arrays, VARRAYs are bounded, meaning they contain a fixed number of elements. This chapter tests (among other things) your ability to define a VARRAY, store a VARRAY in a database table, and add new elements to a VARRAY.
Beginner
8-1. | What is a variable array? |
8-2. | Where can you use variable arrays? |
8-3. | How do you define variable arrays for use in the database? |
8-4. | What is a bounded array? |
8-5. | What SQL syntax do you use to create a variable array column inside a database table? |
8-6. | What syntax do you use to define a variable array as a PL/SQL variable? |
8-7. | For what datatypes can you create variable arrays? |
8-8. | What data dictionary views are available to see which variable arrays exist? |
8-9. | How can you display the structure of a variable array? |
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.