About Oracle

Today I saw a query that prints a calendar for an entire year. I modified it slightly to conform with my local (Dutch) settings: - using ISO...

This morning I read an email discussion about having invalid synonyms in our new Oracle 10.2.0.3 database. I frowned a little, thinking it ...

On Oracle Community in the Database Developers Group a discussion started about having an Obfuscated SQL contest. It was not immediately c...

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...