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

January 10, 2023 Uncategorized

ORDS upgrades are so easy

Just a quick blog post today showing how easy it was for me to upgrade from ORDS 22.1 to the

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

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

October 29, 2021 Uncategorized

Keeping my SQLcl toasty fresh!

With the recent change to the licensing rules for SQLcl, a simple “yum” command on your Linux box gets you

Continue reading

October 7, 2021 Uncategorized

The HOST command in SQL*Plus and SQLcl

Truth be told, the original title of this post was going to be “How I lost an entire day debugging

Continue reading

July 30, 2021 Uncategorized

Time zones, blockchain and stopping hackers

I posted a few months ago about the availability of blockchain tables in 19c, and a fundamental mantra with anything

Continue reading

July 19, 2021 Uncategorized

Drop all baselines

Just a quick tip today on doing a “reset” on your optimizer environment. SQL Plan Baselines are an awesome tool

Continue reading

July 9, 2021 Uncategorized

Keeping OPatch updated with a simple SQL query

I tweeted out this pic yesterday which suggested that by running a SQL query, I could magically keep my OPatch

Continue reading

November 6, 2020 Uncategorized

Application Express – the PSE update

I published a post a couple of days ago about how due to the architecture of PL/SQL and hence Application

Continue reading

November 5, 2020 Uncategorized

Updating my APEX 20.2 installation

One of (or should I say “another of”!) the very cool features of Application Express (APEX) is that by being

Continue reading

Posts navigation

1 2 3 4 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

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    • Digging deeper into SQL under APEX
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 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...