• 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!
October 11, 2022 Uncategorized

Easy data access from Excel #JoelKallmanDay

I suspect Joel would have kittens if he knew I would use the appreciation day to talk about Excel instead

Continue reading

October 6, 2022 Uncategorized

Quick Tip on Datapatch

When I patch my databases through the various Release Updates, I normally do a blog post showing how easy and

Continue reading

October 5, 2022 Uncategorized

CloudWorld – Tuesday Turmoil

I took a quick glance at the schedule for Tuesday for CloudWorld and realised I’m going to need to clone

Continue reading

September 29, 2022 Uncategorized

What are the Squirrels doing? SQL fun and games

Finding interesting data to improve your SQL skills can be a nuisance. There are of course plenty of freely available

Continue reading

September 27, 2022 Uncategorized

Patching just keeps getting easier

After attending a talk by Mike Dietrich at the DOAG conference, I was pleasantly surprised to hear that in 21c,

Continue reading

September 26, 2022 Uncategorized

Can you FLASHBACK an IDENTITY column?

I’ve just got back from the DOAG conference, and what a fantastic event it was. I know I’m considered a

Continue reading

September 9, 2022 Uncategorized

INTERVAL partitions in multiple tablespaces

When the “STORE IN” clause is mentioned for partitioned tables, most people’s mind turn toward hash partitioning, because the usage

Continue reading

August 26, 2022 Uncategorized

XMLTABLE and data “corruption”

One of the cool things with the native SQL handling of complex datatypes is the ability to take something like

Continue reading

August 17, 2022 Uncategorized

The DBMS_REDEFINITION trap

Here’s something to be careful with when it comes to using DBMS_REDEFINITION. Let’s start with the following scenario. I have

Continue reading

August 10, 2022 Uncategorized

Natural Keys versus Surrogate Keys….Here we are again!

Well….that blew up! 😀 Last week I published a video (which you can watch below if you haven’t seen it)

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 … 73 Next Posts»

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

    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to TREAT data in a CLOB as JSON
    • Extended VARCHAR2 and the hidden LOB
    • How to generate random unique values
    • Modifying tables without losing materialized views
    • No more stale statistics in 19c
    • Generating INSERT scripts that run fast!
    • 19c Express Edition #JoelKallmanDay
    • Free In-memory in Oracle Database 19c
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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
     

    Loading Comments...