Re: Natural Join Bug in 11.2.0.1 ??
- From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- To: Tim Hall <tim@xxxxxxxxxxxxxxx>
- Date: Sun, 24 Feb 2013 23:55:50 +0200
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@xxxxxxxxxxxxxxx> 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...
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
