EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Array Types

Oracle provides varying array (varray) type as an ordered set of elements, each of which has the same datatype, and the nested table type. Array Type Editor allows you to create the specification of a varray type or a named nested table type easily and quickly.


Array Type Editor allows you to define array type properties. It opens automatically when you create a new array type and is available on editing an existing one.


To open an array type in Array Type Editor, double-click it in the DB Explorer tree.