Oracle

Oracle Recursive With With Currywürste

At the age of 53 I have discovered the currywurst, a most delicious fast food found all over Germany. This food needs to be commercially ...Read more

When you have to resort to statistics, you know it’s time to redesign the software, or throw it away!

Yesterday the system was running fun. Today it is slow. What changed? How many times has this damn question been asked? The answer is ...Read more

Oracle Execution Plan: Stability or Lability?

From statistics derived from data distribution and hardware performance measurements, and the SQL to be executed, the Oracle Cost Based Optimiser (CBO) is the ...Read more

SQL Server to Oracle migration – déjà vu 002

Having migrated many systems from SQL Server to Oracle, I used to want to cry when I encounter this type of construct. [code ...Read more

SQL Server to Oracle migration – déjà vu 001

Every time I undertake a project to migrate a system from SQL Server to Oracle, I am reminded how deficient and cumbersome it ...Read more

Can an Oracle database trigger fire more than once during the execution of a single atomic piece of DML?

Here is a bit of Oracle 101 code creating some test data that will be used in the remainder of this blog article, ...Read more

In New Zealand, it’s a quarter to two too

There is a 12 hour difference between New Zealand Standard Time (NZST) and Greenwich Mean Time (GMT). Bar daylight saving, this is mighty convenient as ...Read more

Oracle REF CURSORS – Only half a job done, again

Having recently whinged about Oracle REF CURSOR's, I have decided to do it again. So there is no ambiguity, right from the outset ...Read more

Hello ‘Centred Moving Average’ – How very different the source code is in different programming languages!

As part of a data size reduction and chromatogram smoothing PoC project, I needed to implement a Hello World 'Centred Moving Average' algorithm on a ...Read more

Retrieving an Oracle database result set sorted can take longer than retrieving it unsorted ????

Spot the 'error' in the blog title? Do you expect a DBMS to take longer to return a result set ordered or unordered? Ask yourself the ...Read more