In Oracle 12c Valid Time Temporal functionality to define a start and stop time where the data is valid.   This article covers the basic of Valid Time Temporal rules for implementation

Temporal Validity

1. Valid time dimension is placed on a table for each row.
2. Two hidden columns are added to table definition.
3. When querying the table, rows will be displayed regardless of temporal validity, unless you filter based on these two columns.
4. Temporal Validity has no effect on storage or performance.
5. It provides a new filter capability only.
6. Provides a range of time for each row when the data is valid.
7. Date range of validity can be set by user or application.
8. Concepts of Temporal Validity”
   1. VALID TIME – This is a user-defined representation of time. Examples of a valid time include project start and finish dates, and employee hire and termination dates.
   2. Tables with valid-time semantics — These tables have one or more dimensions of user-defined time, each of which has a start and an end.
   3. Valid-time flashback queries — This is the ability to do as-of and versions queries using a valid-time dimension.
9. Valid-time periods require pairs of date-time: start and end.

Larry Catt

OCP