TweetShareSharePin0 SharesYou may be of the belief that “nobody needs more than the 1000 columns we could create in a table in 19c”. You are free the believe that, but let me tell you a little story. There once was a project. At the height of the Telecom billing boom. Thy had implementations in multiple continents for customers whose names you are familiar with. One thing Telecom billing cannot afford is to not keep up with the flood of incoming […]
TweetShareSharePin0 SharesAn old truth in Oracle and just about all relational databases has been that an update on one row by one session will block an update by another session on the same row. Until the first session commits or rolls back. That is until 23ai. Or at least in some very specific scenarios. Let’s consider a situation where we need to track changes to a numeric value up or down by some quantity. This could be the amount in […]
TweetShareSharePin0 SharesIn the last post I talked about a form of syntactic sugar I’m not convinced we really needed. This post on the other hand is about one that I think I’ve needed since the first time I logged on to a SQL-based database. When you put together a test case it is often setup to create misc objects and populate them. The first time you run it it works fine but when you rerun it your create commands fail […]