Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Full outer joins and version 9.2.x

Re: Full outer joins and version 9.2.x

From: dean <deanbrown3d_at_yahoo.com>
Date: 27 Jul 2006 08:25:24 -0700
Message-ID: <1154013924.463066.217870@m73g2000cwd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US