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

March 30, 2021 Uncategorized

Column names you should NOT use

We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good

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

July 24, 2020 Uncategorized

SQL tuning with Hashing and Sorting

Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that

Continue reading

July 21, 2020 Uncategorized

Completely free training for Oracle novices

At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database

Continue reading

July 10, 2020 Uncategorized

How to generate random unique values

When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique

Continue reading

June 11, 2020 Uncategorized

Getting a dog improved my productivity

Today’s blog post is somewhat of a different one. You could perhaps argue that it is even non-technical but bear

Continue reading

June 1, 2020 Uncategorized

Code re-use in PL/SQL might just need SQL

I was doing some code review today of a PL/SQL package, and came across a routine to generate a list

Continue reading

August 16, 2017 Uncategorized

Oracle Code … Not for database people ?

Jump over to the Oracle Code home page and you will see the “mission statement” of the Oracle Code conference

Continue reading

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

  • Powerpoint hack for tech presenters
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to do a GRANT on an entire schema
  • Juice up your JSON on Autonomous
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • Digging deeper into SQL under APEX
  • Don't run tight on PGA
  • The death of UTL_FILE
  • UTL_CALL_STACK lends a helping hand to DBMS_UTILITY
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 821 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