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

May 21, 2023 Uncategorized

Is "fragmentation" still a dirty word?

There was a time in the past where whenever anyone used the term “fragmentation” they would draw the ire of

Continue reading

April 19, 2023 Uncategorized

Sample schemas are now easier than ever

A couple of years back I wrote a post talking about how we wanted to publish the sample scripts in

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

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

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

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

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

Posts navigation

1 2 3 … 14 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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Is "fragmentation" still a dirty word?
    • Implementing dynamic partitions AND subpartitions
    • No more stale statistics in 19c
    • DBMS_JOB and 19c - code changes needed
    • When can I use SQL Macros?
    • Some "must-have" ideas for your next meetup
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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...