Posts tagged: databse

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 .

Read more »