Re: Outer join by (+)
Date: Sat, 29 Dec 2007 10:56:45 +0000
> But when I use (+) syntax, it will be easy to design and understand.
Not if the person reviewing your code is more accustomed to ANSI-standard SQL than out-of-date Oracle peculiarities.
I can read the standard SQL just fine, because that's what I'm used to. I have to stop and think about the Oracle-specific stuff because I'm less familiar with it.
I presume it's the other way around for you for the reverse reasons.
Both situations hereare entirely reasonable, I think, but *looking forward*, sticking to standards-conforming SQL is probably the better approach.
-- AdamReceived on Sat Dec 29 2007 - 04:56:45 CST