Object Oriented Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Object Oriented
  4. 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>