Databases

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

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

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