Uncategorized – Learning is not a spectator sport

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

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

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

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