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

Object Table Nodes

Object tables appear within the Tables node in the Object Navigator. An object table node represents a table created by the SQL statement CREATE TABLE OF. Object table nodes are labeled in the Object Navigator as:

object-table-name (object-type-name)

Each object table node has two subnodes, Triggers and Columns. The Triggers subnode contains all triggers associated with the object table. These triggers are displayed in the same manner as triggers associated with normal, relational tables. The Columns node contains all relational columns and column objects associated with a given object table. Each column is labeled with a name and its type in parentheses.

Object Table node Example

Oracle Object Support in the Object Navigator

Oracle objects examples

The following SQL statements create the object type person_typ and the object table person_tab.

CREATE TYPE person_typ AS OBJECT
(name VARCHAR2(30), address VARCHAR2(60));
CREATE TABLE person_tab OF person_typ;

The subtree for person_tab is:

illustration of subtree for person_tab


Oracle Object Support in the Object Navigator

Column Object node examples