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… 🙂

Cheers

Tim…

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.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.