Re: Full outer joins and version 9.2.x

From: sybrandb <sybrandb_at_gmail.com>
Date: 27 Jul 2006 08:15:03 -0700
Message-ID: <1154013303.729380.190810@i3g2000cwc.googlegroups.com>

dean wrote:
> Oracle (9.2.0.1.0) does NOT have the full outer join bug, all
> subsequent production versions of 9 DO have the bug. Version 10 has
> this problem fixed.
>
> Any tips here? Some of our clients have the not-working versions, and
> some have the good ones. We'd like to be able to do full outer joins,
> and not using the tedious union analog.
>
> Thanks for any help,
>
> Dean

Obvious tip: upgrade to 10gR2
9i will be dead July next year anyway

--
Sybrand Bakker
Senior Oracle DBA

Received on Thu Jul 27 2006 - 10:15:03 CDT