Updating sql record Anty sex chat online profile
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 create collections, you define a collection type, then declare variables of that type.
Varrays are a good choice when the number of elements is known in advance, and when the elements are usually all accessed in sequence.
When stored in the database, varrays retain their ordering and subscripts.
You can model multi-dimensional arrays by creating nested tables whose elements are also nested tables.
Nested tables differ from arrays in two important ways: When you are writing original code or designing the business logic from the start, you should consider the strengths of each collection type to decide which is appropriate for each situation.