Slides 14: Oracle Object-Relational SQL (Cont.)

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