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.
Subscribe to:
Post Comments (Atom)
1 comment:
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"
Post a Comment