A script-enabled browser is required for this page to function properly.

Oracle Object Support in the Object Navigator

Oracle functionality in the Object Navigator provides access to object datatypes, enabling you to program against Oracle data more easily. The added Oracle object support allows you to view user-defined datatypes in a hierarchical format, and to find and display tables, views, columns, triggers, attributes and methods associated with the user-defined datatypes.

The Database Objects node contains the schemas and their objects that you can access in the currently connected database. When connected to an Oracle database, the Object Navigator displays available user-defined datatypes (with their attributes and methods) in the Types node within each schema. Tables, views, columns and triggers associated with the user-defined datatypes are displayed in the Tables and Views nodes.

Specifically, Oracle functionality in the Object Navigator enables you to display and find:

Icons are used to differentiate relational objects and Oracle objects in the Object Navigator. For example, separate icons are used to represent normal, relational tables and object tables, and normal views and object views.


Object Type nodes

Table Type nodes

Varying Array Type nodes

Column Object nodes

Object Table nodes

Object View nodes

Expanding All