Object views appear within the Views node in the Object Navigator. An object view node represents a view created by using the OF object_type clause. Object view nodes are labeled with a name and its type in parentheses. The attributes of the object are not displayed.
Each object view node has two subnodes, Triggers and Columns. The Triggers subnode contains all triggers associated with the object view, including Instead Of triggers. When an Instead Of trigger is associated with a view, the label is displayed as:
trigger-name (INSTEAD OF trigger-statements)
The following SQL statements create an object view.
CREATE TYPE emps_typ AS OBJECT (ename VARCHAR2(30),
esalary number(5,2), deptno NUMBER(2));
CREATE TABLE emps (ename VARCHAR2(30), esalary number(5,2), deptno NUMBER(2));
CREATE VIEW dev_emps OF emps_typ
WITH OBJECT OID (ename)
AS SELECT ename, esalary, deptno FROM emps WHERE deptno = 10;
The subtree for the object view dev_emps is: