Temporal Validity and Flashback Data Archive

Keeping a full history of changes to a table is a common business requirement. Auditors and analysts often need to view data as it existed at some point in the past. This is to ensure regulation compliance or understand how the business is performing.

This session discusses the challenges with writing the SQL to implement these requirements. It then introduces temporal validity and flashback data archive. It shows how you can use these features to simplify working with date ranges and history tables.

This talk is for developers and/or DBAs who build applications or write SQL that uses date ranges and/or captures past data.

Dienstag, 09.05.2017
11:00 - 11:45
Music Hall 1
Fortgeschrittene
English
SQL & PL/SQL
Saxon

Chris Saxon

Oracle Corporation
Chris Saxon is an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL! To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at the The Magic of SQL. If you have questions about working with Oracle Database technology, please reach out to him. You can do this via Twitter or on Ask Tom.

Weitere Vorträge, die Sie interessieren könnten