• 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
November 13, 2020 Uncategorized

SQL Macros = SQL Injection ?

In my recent post about SQL Macros and their availability in 19c, I had some comments about parameter passing, these

Continue reading

November 10, 2020 Uncategorized

Faster software installations

Just a quick tip today thanks to the one of the readers on my blog. If you’re installing Oracle 12c

Continue reading

November 6, 2020 Uncategorized

Application Express – the PSE update

I published a post a couple of days ago about how due to the architecture of PL/SQL and hence Application

Continue reading

November 5, 2020 Uncategorized

Updating my APEX 20.2 installation

One of (or should I say “another of”!) the very cool features of Application Express (APEX) is that by being

Continue reading

November 2, 2020 Uncategorized

Math and SQL: Two of my favourite things

There has always been a special place in heart for the Fibonacci sequence. Decades ago in high school when comparing

Continue reading

October 27, 2020 Uncategorized

APEX 20.2 comes to town (well, to my PC)

As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be

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

October 7, 2020 Uncategorized

Why you keep getting "ORA-01653: unable to extend table"

Space management used to be hard Way back in the good old days…In fact, before I continue, rest assured that

Continue reading

October 2, 2020 Uncategorized

Compression default settings

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

Continue reading

stack of macro vitamins
September 14, 2020 Uncategorized

When can I use SQL Macros?

One of the very cool features we’ve been talking about for 20c is SQL Macros. But you no longer need

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 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
  • No more stale statistics in 19c
  • APEX 20.2 comes to town (well, to my PC)
  • MERGE and ORA-30926
  • DBMS_JOB and 19c - code changes needed
  • My APEX was fine and then it wasn't
  • When can I use SQL Macros?
  • How to upgrade to Oracle 19.8 on Windows
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel