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

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

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

barbed wire security
August 25, 2020 Uncategorized

How to do a GRANT on an entire schema

TL;DR: There is no schema grant command in Oracle, but this routine lets you get close. Why no schema level

Continue reading

August 4, 2020 Uncategorized

Automatically generate audit capture for tables

A weekend audit Often if you see the words “weekend audit” in a non-technical sense, it means that awkward moment

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

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

May 12, 2020 Uncategorized

Arbitrary length addition and subtraction

This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because “NUMBER(38) was not enough”.

Continue reading

April 2, 2020 Uncategorized

Active Data Guard – limitations on ROWTYPE

I had an AskTOM question come in with an issue trying to PL/SQL on an Active Data Guard (ADG) database

Continue reading

February 26, 2020 Uncategorized

When upgrading, choose 19c not 18c

I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is

Continue reading

January 23, 2020 Uncategorized

Handling UTL_FILE_DIR and DIRECTORY objects

A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in

Continue reading

Posts navigation

1 2 3 … 7 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
  • Why you keep getting "ORA-01653: unable to extend table"
  • No more stale statistics in 19c
  • APEX 20.2 comes to town (well, to my PC)
  • Cross-platform database migration
  • The death of UTL_FILE
  • Connection shortcuts with a wallet
  • Complex materialized views and fast refresh
  • My APEX was fine and then it wasn't
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel