Re: Outer join by (+)

From: Adam Cameron <>
Date: Sat, 29 Dec 2007 10:56:45 +0000
Message-ID: <154ib6i7k8x6f$.12bunj69o6ymw$>

> 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.


Received on Sat Dec 29 2007 - 04:56:45 CST

Original text of this message