• 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

Tag: developer

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

October 12, 2020 Uncategorized

The weirdest reason to avoid SELECT *

A quick Google or Bing search and you’ll find no limit to the number of articles on databases that tell

Continue reading

August 19, 2020 Uncategorized

Developer Live wrap up

The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across

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 8, 2020 Uncategorized

Why relying on default DATE formats is a bug

Today’s quick but important message is…don’t be lazy! Look….I get it If given the choice of typing: ’01-JUL-20′ or typing

Continue reading

February 11, 2020 Uncategorized

GROUP BY better than DISTINCT for materialized views

One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the

Continue reading

Posts navigation

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