Identify missing dates in a table

You have a 100,000 row table with lots of data over the course of a year. You know that ideally you should have a number of transactions for every day of the year. However, you are not sure if you have any gaps of time. How can find the gaps of time ?Lots of ways to slice it, but here is how I would do it ... more »
Categories: OracleSQL
PermalinkPermalink