Blog

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

RTFM System.Threading.Semaphore

I recently had the task of debugging a piece of C# that had been translated from C++ by a colleague. All I was ...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

Oracle Virtual Column with Regex & Primary Key

I wrote this trivial piece of test code. I wanted it to work. It is Oracle. I am surprised it worked. No triggers, stored ...Read more

SELECT * FROM TABLE(Oracle REF CURSOR)

Below is the most trivial of C# applications that generates an enumerable anonymous class collection, and spits out the content to the console. ...Read more

If your IT department or company policy is stopping you from conducting business, change it, don’t try to change me !

It is 2016 and after living in the same house for 15 years, I am moving. I am using a recommended solicitor and ...Read more

Oracle database version 13ß anyone?

I have been working with Oracle since version 8i, version 8.1.6 to be exact. Version 8.1.7 was the version number that finally worked. ...Read more

Junk DNA – Junk Oracle, part 0000002

Most high level programming languages implement a selection control mechanism whereby a variable can be used to control program execution via. a multiway ...Read more

Der Hund beißt den Mann

Embedded deep in the psyche of kiwis my vintage is a fear two things: a) the 'Murder House', a place where en-masse dental nurses filled more than ...Read more