Updating reference tables
You can define collection types in a procedure, function, or package.You can pass collection variables as parameters, to move data between client-side applications and stored subprograms.
dating women membership - Updating reference tables
It is a general concept that encompasses lists, arrays, and other familiar datatypes.
Each element has a unique subscript that determines its position in the collection.
PL/SQL offers these collection types: Although collections can have only one dimension, you can model multi-dimensional arrays by creating collections whose elements are also collections.
To use collections in an application, you define one or more PL/SQL types, then define variables of those types.
Within the database, nested tables can be considered one-column database tables.