Playing Fast and Loose with multi-byte characters in Oracle
Friends, DBAs, Devs, "Lemmy" your ears...whilst we take a whistle-stop tour of how the Oracle Database handles multi-byte characters through the medium of a classic rock album.
The Anti-Kyte
Oracle - for when it was like that when you got there
Latest posts
My Year with Gafferbot – an AI Fantasy Football Experiment
Conclusions from my year of finding out how good ChatGPT is at Fantasy Football (not very) and why it works better as a tool than as a replacement.
Getting Data from Oracle into Excel using Python and Pandas
The storm has arrived. The lightning has struck and my data is lurching toward Excel...via pandas
Enable yum package installations in the Oracle Database App Development VM Virtualbox appliance
There was a time when installing the latest version of Oracle on a laptop was rather time-consuming and fiddly.These days however, you can spin up an Oracle database playground in minutes using VirtualBox. Oracle even provide pre-built environments in the form of Virtualbox Appliances which can be found here. Having spent some quality time with [ ]
The Hitchhiker’s Guide to connecting to Oracle from Python
Aliens are among us.If you want proof, just try getting a minor software upgrade applied to a server in a large organisation and you will be sure to run into a level of bureaucracy that can only have been conceived by Vogons.In this post, we ll be looking at the Python libraries available to connect to [ ]
Setting up an Oracle Wallet on a Database Server running Linux
When it comes to allowing os scripts to connect to Oracle without exposing the database password, Oracle Wallet is an effective solution.Whilst I ve looked at this previously, I thought it would be useful to reproduce the steps required to set this up in a more concise post as I ll be referring to them in the [ ]
Linux Expectation Management – scripting password changes using expect and secret-tool
Imagine you find yourself in a situation where you need to keep the passwords of a linux account in synch across multiple servers.You don t have admin privileges, and the accounts may be used in such a way that renders use of SSH keys impractical.Depending on the number of servers involved, changing the password by hand [ ]
Gafferbot – All Systems Meh !
The latest instalment in my ongoing struggle with Artificial Intelligence on the battle ground of Fantasy Football.
Fixing data faux pas with flashback table #JoelKallmanDay
Triggered by traumatic DML errors ? Well, here's one flashback you won't mind having...
Getting Oracle to Create List Partitions automatically
I recently inherited the support of an application that had been written on Oracle 11g. One of the maintenance tasks was to create a new set of partitions every so often so that records with a new value in the list partition key could be created without erroring.Fortunately, the application is now running on 19c, [ ]