§ Class Slides 14: Oracle Object-relational SQL (Cont.)

Class Slides 13: Oracle PL/SQL
Class Slides 15: Object-oriented DBMSs
Home

The following slides discuss the Oracle collection types and methods.

Slide 14.1: Collection types

Slide 14.2: Nested tables
Slide 14.3: Nested tables (cont.)
Slide 14.4: Nested tables (cont.)
Slide 14.5: Nested tables (cont.)
Slide 14.6: Nested tables (cont.)
Slide 14.7: Nested tables (cont.)
Slide 14.8: Nested tables (cont.)

Slide 14.9: VARRAY (Varying-length array)
Slide 14.10: VARRAY (cont.)
Slide 14.11: VARRAY (cont.)

Slide 14.12: Oracle methods
Slide 14.13: Method syntax
Slide 14.14: Method example I
Slide 14.15: Method example II
Slide 14.16: Method example II (cont.)
Slide 14.17: Method example II (cont.)
Slide 14.18: Method example II (cont.)
Slide 14.19: Method example II (cont.)

  ☂ References

Slide 14.a: TutorialsPoint: PL/SQL – Collections






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