Heap Tables vs Object Tables

Heap table is the default oracle table type.

It is a default table definition as you use:

create table test_table

( no NUMBER(5), name VARCHAR2 (10) );

Object table has an logically object oriented architecture to provide reusable components and complex applications.

Object oriented programming is based on object types in PL/SQL.

create table t of some_type;

object type example

~ by enginzorlu on July 31, 2007.