Re: Natural Join Bug in 11.2.0.1 ??

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Sun, 24 Feb 2013 23:55:50 +0200
Message-ID: <CAMHX9JLfxK4rNj-7i4RoNQeaKeb4esYsWVs-UFZ6OOr4KsJHYw_at_mail.gmail.com>

The single only place where I use natural joins is when typing ad-hoc queries against DBA_HIST tables so I wouldn't have to manually join to every single required column in DBA_HIST_SNAPSHOT ... and I use natural join syntax out of laziness there, it's not a good idea otherwise.

-- 
*Tanel Poder*
Enkitec (The Exadata Experts)
Training <http://blog.tanelpoder.com/seminar/> |
Troubleshooting<http://blog.tanelpoder.com/>
 | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923>
 | Voicee App <http://voic.ee/>



On Sun, Feb 24, 2013 at 7:07 PM, 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

>

>

>



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

Received on Sun Feb 24 2013 - 22:55:50 CET