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
- In the Database Explorer window, expand the User Types folder.
- Right-click the Array Types folder, and then click New Array Type on the shortcut menu.
- Provide type name in dialog box opened. Optionally, you can change schema in which the type should be created.
- 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
- In the Database Explorer window, expand the User Types folder.
- Expand the Array Types or Table Types folder.
- 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.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?