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.

1 comment:

Moshe said...

Sounds useful actually. Can this be used for regular columns?
Nothing I find more annoying than WHERE on a column from an OUTER JOIN table and having to write "WHERE column = [value] OR column IS NULL"