• About
  • All Posts
  • 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

Category: Uncategorized

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

January 11, 2021 Uncategorized

How long will the script take to run?

In a world where databases are now the norm, whereas distributing data via a CSV file used to be commonplace,

Continue reading

January 4, 2021 Uncategorized

"Big Mac and Size"..Handling large SQL Macros

Happy 2021 everyone! And what better way to start than a cheesy pun to make you groan and already to

Continue reading

December 21, 2020 Uncategorized

The APEX PSE christmas present!

Its always nice to get fixes to bug just in time for christmas. A while ago I posted an example

Continue reading

December 17, 2020 Uncategorized

2020 in review

Well…its been quite a year!  I downloaded the Oxford “Words of the Year” report which came out with gems such

Continue reading

December 14, 2020 Uncategorized

Solving a John Conway puzzle with SQL

A cool little conundrum came across my email Inbox this week which I thought I’d share. Back in 2016, Pizza

Continue reading

December 7, 2020 Uncategorized

The invisible restore point

I regularly create and drop tablespace on my databases here at home, mainly because they are obviously not used in

Continue reading

December 2, 2020 Uncategorized

The AskTOM multimedia experience!

Most people know AskTOM as the go-to resource for getting answers to the most common and sometimes the most tricky

Continue reading

November 24, 2020 Uncategorized

The power of SQL macros

Here is another example of what I’m sure will just become a plethora of such examples from the community on

Continue reading

November 18, 2020 Uncategorized

The missing multiplication aggregation in SQL

A few days back on Twitter, a cool little discussion arose out of the SQL Daily regular tip – the

Continue reading

Posts navigation

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

Top Posts & Pages

  • PL/SQL in 21c gets amazing new loop iterators
  • How to do a GRANT on an entire schema
  • Solving a John Conway puzzle with SQL
  • APEX 20.2 comes to town (well, to my PC)
  • No more stale statistics in 19c
  • How to upgrade to Oracle 19.8 on Windows
  • Pluggable database and restricted sessions
  • MERGE and ORA-30926
  • The death of UTL_FILE
  • DBMS_JOB and 19c - code changes needed
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel