Archive for the ‘Database Technology’ Category

Date Maths – Oracle

Wednesday, March 24th, 2010

This article continues the Date Maths series and here we are using Oracle. Please refer to the previous articles on SQL Server and DB2 for similar calculations for those database systems. Please refer to the Oracle 11g SQL Reference for more information on the date functions used in this article.

Date Maths – IBM DB2

Thursday, March 26th, 2009

This article continues the Date Maths series, this time with DB2 syntax. Please refer to the other articles in this series on SQL Server and Oracle.

DB2 Client Configuration Issues

Thursday, March 26th, 2009

Recently I had trouble running and configuring a DB2 client installed on Windows XP and thought I'd share what went wrong and how to resolve the issue as it wasn't immediately obvious.

Date Maths – SQL Server

Tuesday, March 17th, 2009

This article is the first in a series that lists date functions and date manipulation calculations for leading database systems and this article looks at the first of those - Microsoft SQL Server. Please refer to the other articles in this series on DB2 and Oracle. Rather than providing a list of ...