-
Set operators – Union, intersect and minus
You’ve probably combined two queries with “union”, but have you looked at the different options for how to combine queries? The set operators are more combining result sets than they are combining queries even if we often think about it is combined queries. Thy need to return the same number of columns of the same…
-
Longs in SQL
Using long datatype is a problem we seldom face with new applications. But some old may still have it if they have not managed to convert to somethings easier to work with. But where I most often encounter it is in Oracles tables. The place that by far most often pops up its ugly head…
-
The lasting impression #JoelKallmanDay
It feels as if this year the feelings are not too raw anymore to even consider writing about Joel. Can anything new be said that hasn’t been said better by much more important people. Probably not, but their story is not my story. A day honouring Joel is not just a day his name brings…