Quick examples into Oracle PL/SQL collections.
There are three types of Oracle Collections you can use in PL/SQL :
- Index-by-Tables : Unbounded, Hashes , Single Dimensional
- Nested-Tables : Unbounded, Array, unordered, Single dimension
- VARRAYS : Bounded, Single Dimension
Each one of these Types have its own features and limitations.
Most of them, share some common functions like EXTEND, FIRST, LAST, ..etc
These self-explaining examples; helps the reader get a first introduction into each collection type .