Materialized views (MV’s) – the developers go-to tool for poor performing queries. 🙂 Of course that isn’t really their only purpose, and creating one…
Read more →I’m quite a fan of row generators. If I know I need a row for every day of the year for example, I generally…
Read more →I was inspired to post this blog by a post on the OTN Forums where a user was asking about calculating the consumption of…
Read more →Back onto analytical views, today I’m going to demo using calculated fact measures in analytic views as opposed to standard fact measures.You may recall…
Read more →It’s always nice to see new database features, and I especially like to see features which implement concepts that are commonly coded at the…
Read more →In my previous blog post An Introduction to Analytic Views in Oracle 12.2 I briefly mentioned that one of the killer features of Analytic…
Read more →In my last blog post on Oracle Database 12.2 I mentioned the new Analytics View feature. Now in this post I am going to…
Read more →Relationship Issues No, this isn’t the latest agony aunt column – I’m talking about data relationships! Specifically, relationships between columns within single tables. For…
Read more →I recently needed to use the LISTAGG function in a custom Oracle ODI interface. However to my dismay I found that ODI didn’t recognise…
Read more →The WITH clause (or subquery factoring clause) is a very useful construct. It allows us to materialize the results of a SQL statement to…
Read more →