• About
  • All Posts
  • 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
February 19, 2021 Uncategorized

Free space requirements for ALTER TABLE

One of the very cool features from 12.2 onwards is that the vast majority of segment operations that require rewrite

Continue reading

February 12, 2021 Uncategorized

The podcast is go!

A few weeks back, I posted that I would give podcasting a trial. I’m thrilled to see that the response

Continue reading

February 9, 2021 Uncategorized

Expanded TYPE definitions for PL/SQL 21c

There has always been that odd conflict between the language you use for SQL versus the language you use for

Continue reading

February 8, 2021 Uncategorized

Counting business days between 2 dates

One of the most commonly hit questions on AskTom is how to count the number of work days (Mon =>

Continue reading

February 3, 2021 Uncategorized

Blockchain tables are here in 19c!

Slow down there….Take a breath. Because if you’ve read the title of this post and you’re already logging on to

Continue reading

February 1, 2021 Uncategorized

Blockchain tables in 21c? A word of warning

As I write this, the moment you do a browser search for “blockchain”, the last thing you will get a

Continue reading

January 27, 2021 Uncategorized

Datatype conversions – strange internal function

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

Continue reading

January 22, 2021 Uncategorized

New Year … new idea … new channel

I’ve done a lot of presentations over the years, written a ton of blog posts, and over the past  5

Continue reading

January 15, 2021 Uncategorized

PL/SQL in 21c gets amazing new loop iterators

“It’s a dead language” people said. “There’s never anything new” people said. Well, let me serve those people a slice

Continue reading

January 11, 2021 Uncategorized

How long will the script take to run?

In a world where databases are now the norm, whereas distributing data via a CSV file used to be commonplace,

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 61 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.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • LOBs from afar
  • APEX 20.2 comes to town (well, to my PC)
  • No more stale statistics in 19c
  • Why you keep getting "ORA-01653: unable to extend table"
  • Pluggable database and restricted sessions
  • NULL's vs NOT NULL's and Performance
  • Updating indexes with partition maintenance
  • Listener log data mining with SQL
  • How to generate random unique values
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×