About Oracle

We all know what the 'ww' date format element does, right? It provides the week number such that January 1 is always in week 1. The ...

The sequence within parent column is the column in a detail table that, together with the foreign key column to the master table, constitute...

The client I currently work for has quite a few special tables containing flexible attributes. These tables have one foreign key to another ...

This tagging thing has reached me as well. I saw it coming to me via Eddie Awad , who tagged Laurent Schneider , who tagged Chen Shapira , w...

A few weeks ago I wrote about four oddities I encountered when doing a little research into several 11g features in this blog post . And thi...

I don't know about other countries, but here in the Netherlands every radio station seems to have its own top 50/100/500/2000 of hits. S...

Implementing a check constraint with sysdate in it, is not possible. Not until 11g that is, where you can use a trick to do this using virtu...