My Oracle Support Banner

12.1 New Feature: Valid Time Temporal (Doc ID 1524779.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


 The document describes and provides some simple examples the Temporal Validity feature that was introduced in 12.1 for tables.


 Valid-time dimension is a synonym of Valid-time column in this article.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Brief description of the feature
 How to introduce temporal validity on a table
 How to use Temporal Validity
 Ordinary query and DML
 Flashback queries
 AS OF PERIOD FOR <valid_time_column> <timestamp>
 VERSIONS PERIOD FOR <valid_time_column> BETWEEN <timestamp> | MINVALUE AND <timestamp> | MAXVALUE
 Limitations and Restrictions for table support of Temporal Validity

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.