Learning is not a spectator sport

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

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

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

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

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

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

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

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

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

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