Faster DISTINCT operations in 19c
If I gave you a telephone book and asked you to tell me how many distinct street names are present
How to stop your site from being Clickjacked!
In the language of the millennials I should start this post with “TIL”, but for the rest of us out
How to change Scheduler maintenance windows
There are a few possible reasons why you might be one of those people why you might be using your
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
How to TREAT data in a CLOB as JSON
What better way to start a new week than with a cheesy title to my blog post! But there is
SQL tuning with Hashing and Sorting
Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that
DDL gets my goat
First things first. If you are not familiar with the term “gets my goat” then you can find a definition
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
Upgrading…Its Time!
Gough Whitlam was an Australian politician who rose to power in the 1970s with the campaign slogan “It’s Time!”. Politics
How to generate random unique values
When sequences won’t do In an Oracle database if someone comes to you and says “I need to generate unique
