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.
Immutable tables
External tables
Read-only
tables.
Index