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

Class Slides 14: Oracle PL/SQL
Class Slides 16: Object-oriented DBMSs
Home

The following slides discuss the Oracle collection types and methods.

Slide 15.1: Collection types

Slide 15.2: Nested tables
Slide 15.3: Nested tables (cont.)
Slide 15.4: Nested tables (cont.)
Slide 15.5: Nested tables (cont.)
Slide 15.6: Nested tables (cont.)
Slide 15.7: Nested tables (cont.)
Slide 15.8: Nested tables (cont.)

Slide 15.9: VARRAY (Varying-length array)
Slide 15.10: VARRAY (cont.)
Slide 15.11: VARRAY (cont.)

Slide 15.12: Oracle methods
Slide 15.13: Method syntax
Slide 15.14: Method example I
Slide 15.15: Method example II
Slide 15.16: Method example II (cont.)
Slide 15.17: Method example II (cont.)
Slide 15.18: Method example II (cont.)
Slide 15.19: Method example II (cont.)

  ☂ References

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






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