Video : Temporal Validity in Oracle Database 12c Onward


In today’s video we discuss how Temporal Validity can make querying of effective date ranges simpler in Oracle 12c and beyond.

The video is based on this article.

The syntax looks similar to Flashback Query and Flashback Version Query.

The star of today’s video is a knitted creation by the wife, Debra Lilley. I’m not entirely sure what it is. Maybe a sea squirt? I’m sure I’m going to get into trouble for not knowing, as I’m sure it’s a perfect representation… 🙂



Update. Debra just told me it’s a Coronavirus… 🙂

Author: Tim...

DBA, Developer, Author, Trainer.

One thought on “Video : Temporal Validity in Oracle Database 12c Onward”

  1. Damn! I wish I had known about this syntax on my previous job. A lot of queries would have looked a lot nicer.
    I forwarded a link to my old colleagues.

Comments are closed.