"TurkBear" <john.greco_at_dot.state.mn.us> wrote in message
news:5f23ivoldp71tp5eoh0hcfhoki03mtpjqb_at_4ax.com...
> "Maximus" <qweqwe_at_qwqwewq.com> wrote:
>
> >"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> >news:9lu2ivon3ko205r7pn3njef38t5dlhim30_at_4ax.com...
> >> On Fri, 25 Jul 2003 15:39:32 GMT, "Maximus" <qweqwe_at_qwqwewq.com>
> >> wrote:
> >>
> >> >It's an obsoleted outer join operator, I think particualr to Oracle.
> >>
> >> There is nothing obsolete to it, and it is part of the sql standard.
> >> Go get your school money back
> >
> >It's not standard SQL it's an Oracle extension. This could be why Oracle
> >refers it as the "Oracle join operator." This is a rather proprietary
term
> >for something that you claim is an SQL standard. Oracle also does not
> >recommend using the (+) operator in favour of the left [outer] join
syntax
> >because of numerous restrictions.
> >
>
> You seem a little quick to provide partially true info...
> Oracle did not support the use of LEFT OUTER ( or RIGHT OUTER) JOIN
statements
> until Version9 - Any users that are not at that version ( and millions are
not) would find your answer very confusing..
Quite right, I'm not familiar with the older versions of Oracle that did not
support ISO 99 syntax, I stand corrected.
Received on Fri Jul 25 2003 - 15:24:19 CDT
