Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Full outer joins and version 9.2.x
We cannot dictate to a large company when to update their oracle
servers!
sybrandb wrote:
> 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:25:24 CDT