立即与支持人员聊天
与支持团队交流

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级