4 ms·
I also find the Oracle outer join operator (+) easier to use. I just searched the full (Oracle) sql codebase of the project I'm working on, and it seems that t
by miahi 15y ago
I also find the Oracle outer join operator (+) easier to use.
I just searched the full (Oracle) sql codebase of the project I'm working on, and it seems that there is no clear winner in the "outer join" vs "(+)" battle (outer = 46%, (+) = 54%). There is no code style requirement for joins.
- jmelloy 15y agoI have trouble with the oracle syntax once you get to two or three tables left joined against each other, and consider it more a relic of old oracle programmers than any actual advantage one way or the other.
- fendale 15y agoI think I read recently that using the Oracle (+) operator can give you the error "cannot outer join to more than one table" if you try to outer join to two or more, but the ANSI syntax will allow you to do that - I really should test this out ... edit - I tried this out and right now cannot get that error, so not sure where I got that idea from.
- LewisCr 15y agoThis code: Where a.client_id = c.client_id And a.client_id = b.client_id (+) And c.client_id = b.client_id (+) Doesn't fly in our database