12c Temporal Validity Support in SQL Developer Data Modeler

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

Today’s question: can I design a table that takes advantage of the new Temporal Validity feature in Oracle Database 12c?

Today’s answer: ‘Yes.’

In a nutshell:

Temporal Validity Support lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the start and end dates or time stamps of the period for which a given record is considered valid. Examples of time-based validity are the hire and termination dates of an employee in a Human Resources application, the effective date of coverage for an insurance policy, and the effective date of a change of address for a customer or client. [DOCS]

There’s a property in the Table editor that allows you to define the start and end times required to specify the ‘temporal validity’ of your data.

You can find better examples and sample SQL to play with this in the aforementioned DOCS link.

You can find better examples and sample SQL to play with this in the aforementioned DOCS link.

Note that I’m running SQL Developer v4.1 connected to a 12.1.0.2 Oracle Database.

New SQL syntax to learn, VERSIONS PERIOD FOR user_valid_time BETWEEN

New SQL syntax to learn, VERSIONS PERIOD FOR user_valid_time BETWEEN

Next question?

Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *