Thursday, January 28, 2010

Testing Testing

The different ways to test a DB connection:

MySQL/PostgreSQL/MS SQL use: SELECT 1
DB2 use: SELECT 1 FROM sysibm.sysdummy1
Oracle use: SELECT 1 from dual

Why do DB2 and Oracle always have to be different? Just because they can?