• 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!

Category: Uncategorized

March 7, 2023 Uncategorized

Avoiding INSERT glitches with SQL*Plus and SQLcl

Sometimes in data centric applications, we want to store metadata (such as HTML or CSS or other such text) in

Continue reading

February 21, 2023 Uncategorized

A key difference between TP and TPURGENT

When you are using Autonomous Transaction Processing database, as well as the LOW, MEDIUM and HIGH services that are also

Continue reading

February 6, 2023 Uncategorized

When EZCONNECT is not so easy

Pop over to AskTom and you’ll see two entries that commonly pop up on our top 20 most viewed questions

Continue reading

February 2, 2023 Uncategorized

The new forums

New year and I knew you want some new news about new forums!  (That’s a lot of “new” 😀) I’ll

Continue reading

January 25, 2023 Uncategorized

SQL engine and PL/SQL functions

A common pattern I see in database code is the use of a PL/SQL package to hold constants to be

Continue reading

a cassette tape with the tape unravelling out of it
January 12, 2023 Uncategorized

The podcast is back for 2023!

Normally I don’t dedicate a post to just a podcast episode, because you can see them all here, but since

Continue reading

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

January 6, 2023 Uncategorized

Audit trails and the importance of TIMEZONE

I threw this little puzzle out on Twitter just before the New Year It was a little bit mischievous of

Continue reading

January 2, 2023 Uncategorized

TEMP is a four letter word

Happy New Year to all! With the next long term release (23c) probably due some time this year, let’s start

Continue reading

a christmas tree
December 19, 2022 Uncategorized

2022 – the year in review

Well, its been quite a year 🙂 Probably the highlight for me, and I’m sure for many others, was the

Continue reading

Posts navigation

1 2 3 … 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
    • Free In-memory in Oracle Database 19c
    • Generating INSERT scripts that run fast!
    • 19c Express Edition #JoelKallmanDay
    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...