Collection Types

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

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

Creating a Varray or Table Type

  1. In Database Explorer, expand the User Types folder.
  2. Right-click the Array Types folder, and then click New Array Type in 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 the Table Types folder.
  3. Right-click a required type, and then click Edit Type in the shortcut menu.

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

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