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
Developer Live wrap up
The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across
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
