Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating