• 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: pivot

October 2, 2019 Uncategorized

PIVOT does not work with materialized view refresh

We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL

Continue reading

September 18, 2015 Uncategorized

Row transposition

Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:

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.

Tweets by connor_mc_d

Top Posts & Pages

  • Powerpoint hack for tech presenters
  • How to do a GRANT on an entire schema
  • Why you keep getting "ORA-01653: unable to extend table"
  • A simple benchmark harness
  • Juice up your JSON on Autonomous
  • Automatically generate audit capture for tables
  • Digging deeper into SQL under APEX
  • No more stale statistics in 19c
  • A justification for referential integrity constraints
  • We killed sequence contention!
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 821 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