In a previous post on SQL macros in Oracle Database 20c we saw how SQL macros can be used to create a kind of “parameterized” views to establish a simplified access tier to temporal data. In this post I’d like to explore more possibilities to hide the complexity of SQL statements behind a functional syntax provided by using SQL macros. As an example we’ll stay with a temporal data introduced in the previous post and explore how we can do a temporal join of this versioned data.
Continue reading![](https://blog.sqlora.com/en/wp-content/uploads/sites/2/2020/03/temporal_join-624x303.png)
Temporal Joins with SQL Macros in Oracle 20c
Leave a reply