SQL

Junk DNA – Junk Oracle, part 0000003 …. DROP TABLE IF EXISTS

Almost every week I write or enhance software components that are deployed into a PROD environment. Every week, the full-fat versions of the ...Read more

PostgreSQL Recursive Common Table Expression WITH Currywürste – My First Development Experience with PostgreSQL

My mother tongue is Oracle, not PostgreSQL. PostgreSQL however has exceptionally good press for being a snappy comprehensive quality product, and with great documentation to boot. ...Read more

Yet another gripe from a Software Developer: I really do wish people wouldn’t “Help Me Out”

Kevin Bacon is one cool dude. From his performances in The River Wild and Footloose, to the unforgettable Hollow Man, he constantly exudes ...Read more

Oracle Recursive With With Currywürste

At the age of 53 I have discovered the currywurst, a most delicious fast food found all over Germany. This food needs to be commercially ...Read more

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

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

ANSI SQL/Foundation

I have believed for some time that the SQL FROM clause is optional, that is optional from the standpoint of ANSI/IEC/ISO standards, not from ...Read more

Database table column aliasing, and coding standards

Here's a question I posed to myself recently, during a database code maintenance/upgrade cycle. Can adding a column to the underlying database table break ...Read more

Querying database table columns that don’t exist

I had a recent client request that, distilled down to its very basics, was 'could you please write some example code that demonstrates ...Read more

SQL