Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

You can also use an object type to define an entire table, and the table is known as an object table

SQL> SQL> CREATE or replace TYPE EmployeeType AS OBJECT (   2    id          NUMBER,   3    name        VARCHAR2(15),   4    description VARCHAR2(22),   5    salary       NUMBER(5, 2)   6  );   7  / Type created. SQL> CREATE TABLE object_employee OF EmployeeType; Table created. SQL> SQL> desc object_employee;  Name                Null?    Type  ID                           NUMBER  NAME                         VARCHAR2(15)  DESCRIPTION                  VARCHAR2(22)  SALARY                       NUMBER(5,2) SQL> SQL> drop table object_employee; Table dropped. SQL>