Re: Natural Join Bug in 11.2.0.1 ??

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Sun, 24 Feb 2013 20:28:28 +0100
Message-ID: <CAA9w=EsFip1T91ft+seAW0wBbeBMpk9Ms1h3Qf_VjFgd2T6ELg_at_mail.gmail.com>

It works as advertized... :-)
On Sunday, February 24, 2013, Hemant K Chitale wrote:

> In my class notes for the students, I have now denonstrated how a NATURAL
> JOIN between EMPLOYEES and DEPARTMENTS produces the wrong results.
> On Feb 25, 2013 1:07 AM, "Tim Hall" <tim_at_oracle-base.com <javascript:;>>
> wrote:
> > It's important that people know what a natural join is, but I don't
> > believe they have a place in software development. In using one you are
> > stating that you are happy that any future changes to the tables in
> > question will have no impact on your query. This can not be guaranteed.
> :-)
> >
> > Cheers
> >
> > Tim...
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sent from Gmail Mobile


--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 24 2013 - 20:28:28 CET