• 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

December 6, 2022 Uncategorized

Faster operations with CLOBs

Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less

Continue reading

November 30, 2022 Uncategorized

The cost of DBMS_PARALLEL_EXECUTE

I had an inquiry about the performance of DBMS_PARALLEL_EXECUTE today from a customer. Whilst the utility (as the name suggests)

Continue reading

November 23, 2022 Uncategorized

Google-like search for your entire application

I published a video today showing how to use a Text index to pick up search terms from multiple tables

Continue reading

November 11, 2022 Uncategorized

I did not write this blog post

In fact…no-one wrote this blog post! Here’s a little bit of fun for you. I was doing my normal doom

Continue reading

November 9, 2022 Uncategorized

From stateful to stateless PL/SQL

I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little

Continue reading

November 2, 2022 Uncategorized

A Security Disaster

There has been a lot of coverage here in Australia recently about one of our popular telco’s getting hacked due

Continue reading

November 1, 2022 Uncategorized

The Halloween Pumpkins of Terror

For some giggles this Halloween, over on Twitter I tweeted some worst practices each hour during Halloween in the guise

Continue reading

October 27, 2022 Uncategorized

CloudWorld is done!

Just a quick post with a few highlights from CloudWorld, but really this is all about getting you the slides

Continue reading

October 20, 2022 Uncategorized

CloudWorld – Thursday Thrills

OK, lets close this week on a strong note with another bunch of awesome tech sessions on the database, APEX

Continue reading

October 19, 2022 Uncategorized

CloudWorld – Wednesday Avawanche

Well my alliteration puns might not be so good, but the volume of cool stuff on Wednesday at CloudWorld is

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 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
    • No more stale statistics in 19c
    • Modifying tables without losing materialized views
    • Free In-memory in Oracle Database 19c
    • 19c Express Edition #JoelKallmanDay
    • Generating INSERT scripts that run fast!
    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...