• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: analytics

April 27, 2021 Uncategorized

Why does SUM look broken for window functions?

TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation

Continue reading

July 4, 2016 Uncategorized

LAG / LEAD quick tip

As most of us know, with LAG and LEAD or more generally, any analytic function that may extend “past” the

Continue reading

January 27, 2016 Uncategorized

Histograms on data (not the optimizer)

I’ve been doing a series on Analytics here but if you need to group data into ranges, you don’t necessarily

Continue reading

November 25, 2015 Uncategorized

KISS video series for Analytic functions

Analytic functions still bamboozle many SQL practitioners out there.  So I’m building a suite of videos to walk people through

Continue reading

January 1, 2015 Uncategorized

Analytics Demo Scripts

Video 2: Ranking rows https://livesql.oracle.com/apex/livesql/s/ch1tefsz0mc75pk4ix2jbfja7 Video 3: More options for ranking rows https://livesql.oracle.com/apex/livesql/s/clebs8f5n4kr2b3vjvnvvgxkn Video 4: Using the Tabibitosan method for

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Version 7 was so much better...
  • The Fractional Part of a TIMESTAMP. Be careful.
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • A little known RI clause
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • MERGE and ORA-30926
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 810 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar