Thursday, August 27, 2009


My translation of Johann Gottfried Herder' classic poem:

Our life is but a dream, a dream
Here in this Earthly sphere
Like shadows on the wavecrest
we rise and disappear.

We mark our plodding journey
in Time and Space,
in the midst of eternity.

Monday, February 9, 2009

Outer joins have a (+)?

Oracle Joins have a weird syntax for outer joins. The table that shows null values has a (+) appended to it, IIRC. I don't know if this is ANSI syntax or Oracle's own. I suspect it's Oracles; whatever the case, I don't like it. It breaks the standard of SQL syntax being English words ( FROM, WHERE, LIKE ), instead of weird operator symbols.