Accessing Oracle from Perl
This weekend had bad weather. Rain pouring from the sky and a drop of snow. Such weather is good to undertake something that is absolutely useless like writing a Perl…
This weekend had bad weather. Rain pouring from the sky and a drop of snow. Such weather is good to undertake something that is absolutely useless like writing a Perl…
Sorry to say, but I love Microsoft Visio. Plse do not spread the word. But from time to time, I had to create a document that served two distinct groups:…
For some reason, I always overlooked the possibility to include pictures in a database. I decided to overcome this flaw and started experimenting with it. The first step was to…
I installed teradata recently. The installation was really straight forward. And as a bonus, you get tons of client tools. It is possible to use several clients to start your…
Yesterday, I started installing Oracle. I decided to download the newest version: version 11g R. I used windows xp as a platform with DHCP switched off. It really looked simple:…
Yesterday evening, I received a copy of Expressor. This is a free ETL tool which made a very good impression to me. I downloaded the copy from http://www.expressor-software.com . The…
I was asked a few days to write a SQL that would retrieve the one but latest row. Take as an example a few rows below: we have a several…
SQLite is the smallest database server we know. The engine itsself is about 500 KB – considerably less than other engines. It can be downloaded from http://www.sqlite.org/ . Once downloaded,…
In the test phase, we would like to create a nice list of encountered bugs. In most situations a project assistant is given the task to maintain this list. All…
Last week, I gave a course on data warehousing. When I overviewed the theory, I noticed I had to spend some time on “disabling the the referential integrity constraints”. I…