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.
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.
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.