Re: Outer join by (+)
From: Adam Cameron <adam_junk_at_hotmail.com>
Date: Sat, 29 Dec 2007 10:56:45 +0000
Message-ID: <154ib6i7k8x6f$.12bunj69o6ymw$.dlg@40tude.net>
Date: Sat, 29 Dec 2007 10:56:45 +0000
Message-ID: <154ib6i7k8x6f$.12bunj69o6ymw$.dlg@40tude.net>
> 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.
IMO.
-- AdamReceived on Sat Dec 29 2007 - 04:56:45 CST