Collection Type

User-defined array type is an ordered set of elements, each of same datatype.

Using dbForge Studio for Oracle you can create, edit and delete varray and table types.

Creating a Varray or Table Type

  1. In the Database Explorer window, expand the User Types folder.
  2. Right-click the Array Types folder, and then click New Array Type on the shortcut menu.
  3. Provide type name in dialog box opened. Optionally, you can change schema in which the type should be created.
  4. Click the Create button.

A new document appears with template in the Design view. Choose type parameters and save the document to have the type created. You can switch to the Text view to inspect generated SQL query.

Editing a Varray or Table Type

  1. In the Database Explorer window, expand the User Types folder.
  2. Expand the Array Types or Table Types folder.
  3. Right-click a required type, and then click Edit Type on the shortcut menu.

To compile a varray type or a table type, right-click a required type, and then click Compile on the shortcut menu. If operation succeeds a type changes its status from invalid to valid.

To delete a type, click Delete on the shortcut menu.