Re: Natural Join Bug in 11.2.0.1 ??

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Mon, 25 Feb 2013 02:46:17 +0800
Message-ID: <CAMNBsZvosmD5Cv=XLUC0cjPTVSOWnOP-0kivUtQnwZDXNzrFQA_at_mail.gmail.com>



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> 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
Received on Sun Feb 24 2013 - 19:46:17 CET

Original text of this message