Re: should one use ANSI join syntax when writing an Oracle application?

On 10/17/06, Ken Naim <kennaim@xxxxxxxxx> wrote: 

I find the ansi syntax verbose and agree with the poster who said that
while
it highlights the joins it obfuscates the tables which I find more
important
while debugging data issues. I don't understand why we need the ansi
syntax
to separate the join and filter conditions, I have been doing it for years
in the where clause, first the joins then the filter, look at any of my
queries and it is plain as day even with 20 tables 6 inline views and 4
sub-queries.


as an exercise it might be illuminating to supply one such query to someone
who is competent in sql, but unfamiliar with your work and ask them which
tables are joined to which and how?

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: