- Is an object-relational DBMS.
- Supports user-defined datatypes and member functions.
- Provides SQL and PL/SQL object extensions.
- The user-defined datatypes can be used in a relational table. The data actually resides as column values in the table.
- OO features not yet supported include classes, inheritance, and encapsulation, and all data are public rather than private.
|
|
- Built-in datatype such as
INTEGERis a datatype built-in to the server. It provides efficient code generation for predefined operations. - User-defined datatype can be a combination of built-in and previously defined user-defined types.
- An object type is a user-defined datatype that has attributes and methods, which are the set of allowed behaviors of the object types.
- A collection object type is a collection of scalar or object types including nested tables and varrays.
REFis a reference to an object stored in a database table.- A large object is capable of storing large volumes of data.