Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

Use objects in SQL, First, you can use object types as attributes in a traditional relational way)

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(   2      employee employeeType,   3      remarks_tx VARCHAR2(2000)   4  ); Table created. SQL> SQL> drop table t_emp; Table dropped. SQL> drop type employeeType; Type dropped. SQL>