Varray Editor
Use the VArray Type Editor to create varying arrays that can be used to:
- loop through the elements in order
- store only a fixed number of items
- retrieve and manipulate the entire collection as a value.
|
About Varying Array Objects |
The varying array is a collection type you can use when you want to retrieve entire collections as a whole. They are best suited for small collections. If you require a large, efficient collection, you would be better to use a nested table collection type (see Editing a nested table). You must set a maximum number of elements for a varying array but you can change this limit. A varying array object is normally stored in line, that is, in the same tablespace as the other data in its row. The characteristics and usage of this database object are described in Oracle documentation. |