Online Documentation for SQL Manager for Oracle
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.
- Using Navigation bar and Toolbar
- Creating/editing array type
- Browsing object dependencies
- Viewing DDL definition