An object whose value is NULL is called atomically null. An atomically null object is different from an object that has null values for all its attributes.

A large object data type whose value consists of raw binary data.

The large object (LOB) data type whose value is composed of character data corresponding to the database character set.

An object that is stored as a column of a relational database table (as opposed to an object table). A column object can also be an attribute of another object. A column object is also known as a stored inline object or an embedded object.

An attribute of a column object.

A method call that is dispatched at run-time to the nearest method implementation when there are multiple implementations of the same method using overriding.

An object that is not a collection and is not composed of other types.

An attribute of a leaf-level scalar object.

An invocation where all arguments are literals or invocations of literal methods. Arguments cannot be variables.

A view that contains both the query and its results.

Collection types whose elements are collection types, either directly or indirectly.

An operator that combines elements of two nested tables into a single nested table.

An unordered set of data elements of the same data type.

The process of removing redundancy in data by separating the data into multiple tables.

A column of user-defined types or abstract data types (ADT)s .

Identifier for a row object which can be either system-generated (default) or based on a primary key using the CREATE TABLE statement.

An instance of an object type. Also referred to as an object.

A table in which each row represents an object. See row object.

The type of the object instance. It is similar to a record that has methods. Object types are user-defined.

A table that contains a nested table.

Fetching.

The Oracle procedural language extension to SQL.

Allows handling data types and methods generically using the same interface. In polymorphic overriding, subtypes redefine a method they have inherited. In polymorphic overloading, there may be several versions of the same method, with different parameters.

The column or set of columns specified in the PRIMARY KEY constraint of a table.

An Oracle built-in data type that encapsulates references to row objects of a specified object type.

An object that is stored in a complete row in an object table.

Adding new attributes or methods to a subtype that the parent supertype does not have, or changing the implementation of a method or methods.

A PL/SQL block that is stored in the database and can be executed from an application.

A supertype is substitutable if one of its subtypes can substitute or stand in for it in a variable or column whose declared type is the supertype.

The modification of a subtype of a type, typically using an ALTER statement.

An ordered set of data elements, that are of the same data type or a subtype of the declared data type.