Search notes:

Oracle: Tables

A table is the fundamental object to store data in a database.

It consists of rows and columns.

Records

Records in a table are identified by a rowid.

High Water Mark (HWM)

The HWM is used (among others?) for direct path inserts.

See also

The SQL noun table

Virtual columns

A partitioned table allows to distribute records to several partitions, each of which can be managed individually.

A period definition clause adds support for temporal validity.

A table's default Degree of Parallelism (DOP)

With Oracle's Workspace Manager, its possible to store multiple versions of data in a table (if the table was version enabled).

Data is added to a table with the insert and the merge statement.

«Result cache» tables

Polymorphic Table Functions (PTFs)

Storing nested tables in a table.

Types of tables and the data dictionary

dba_catalog

SQL Script to show tables' columns and position of primary keys.

dbms_space.create_table_cost estimates the requred size of a table to be created, given its storage attributes.

Other Oracle object types, for example the cluster which allows to store data from one ore more tables.

Compare the data of two tables

Private temporary tables

Blockchain tables, introduced with 21c.

External tables