May 2000
Intermediate to advanced
594 pages
11h 32m
English
Content preview from Oracle PL/SQL Programming: A Developer's Workbook
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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? |