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

September 11, 2020 Uncategorized

Age calculations – Just how old ARE you?

Any database application that stores information about people will very likely store a person’s date of birth as part of

Continue reading

girl floating from ceiling
September 8, 2020 Uncategorized

The CEIL function, dates and floating point numbers

Oh yes indeed, I have dug deep into the well of cheesy blog post titles for this one . But

Continue reading

ace revealed by magician
September 7, 2020 Uncategorized

Docs hack to save you time!

The tech world is a big and varied place, so whilst there are some database customers running on 19c and

Continue reading

19c scheduler and jobs
September 3, 2020 Uncategorized

DBMS_JOB and 19c – code changes needed

Here’s a “gotcha” brought to my attention by one of our AskTOM readers. I’ve mentioned in the past that DBMS_JOB,

Continue reading

random dice toss
September 1, 2020 Uncategorized

Frequency histogram – where did that estimate come from?

Frequency histograms in any version of Oracle are pretty cool things, so whenever you have a distribution of data that

Continue reading

woman working on flexibility
August 31, 2020 Uncategorized

How to control resource usage on Autonomous

When you connect to your Autonomous Database, you get to choose from some predefined services. The services available depends on

Continue reading

recycle bin
August 27, 2020 Uncategorized

How to make queries to DBA_FREE_SPACE faster

The other day as my PC popped up its usual “Hey, you really should look at buying a bigger disk”

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

How to upgrade to Oracle 19.8 on Windows

As always, you should follow the instructions in the README.html that comes with the Release Update, but because I know

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 … 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
  • New Year ... new idea ... new channel
  • Why you keep getting "ORA-01653: unable to extend table"
  • The death of UTL_FILE
  • No more stale statistics in 19c
  • APEX 20.2 comes to town (well, to my PC)
  • Connection shortcuts with a wallet
  • Complex materialized views and fast refresh
  • NULL's vs NOT NULL's and Performance
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel