The following slides discuss the Oracle collection types and methods.

Slide 10.1: Collection types
Slide 10.2: Nested tables
Slide 10.3: Nested tables (cont.)
Slide 10.4: Nested tables (cont.)
Slide 10.5: Nested tables (cont.)
Slide 10.6: Nested tables (cont.)
Slide 10.7: Nested tables (cont.)
Slide 10.8: Nested tables (cont.)
Slide 10.9: VARRAY (Varying-length array)
Slide 10.10: VARRAY (cont.)
Slide 10.11: VARRAY (cont.)
Slide 10.12: Oracle methods
Slide 10.13: Method syntax
Slide 10.14: Method example I
Slide 10.15: Method example II
Slide 10.16: Method example II (cont.)
Slide 10.17: Method example II (cont.)
Slide 10.18: Method example II (cont.)
Slide 10.19: Method example II (cont.)



      “For I will wear my heart upon my sleeve, For daws to peck at.”    
      — Shakespeare, Othello