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.