Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

Alternatively, you can create an object table

In the object table, where each attribute becomes a column. Each row in the object table contains a unique object identifier. SQL> create or replace type employeeType is object (   2      empNo    NUMBER,   3      eName    VARCHAR2(10),   4      job      VARCHAR2(9),   5      mgr      NUMBER,   6      hireDate DATE,   7      sal      NUMBER,   8      comm     NUMBER,   9      deptNo   NUMBER  10  )  11  / Type created. SQL> SQL> create table t_emp of employeeType; Table created. SQL> SQL> drop table t_emp; Table dropped. SQL> drop type employeeType; Type dropped. SQL>