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.