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