Re: mix ANSI and Oracle JOINs?

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 23 Dec 2010 09:38:09 -0800
Message-ID: <AANLkTimh-R=y2HwXjW2mc_rPArGK==2yVo7XoyuyLkd5_at_mail.gmail.com>

On Thu, Dec 23, 2010 at 8:08 AM, Kenneth Naim <kennethnaim_at_gmail.com> wrote:

> I also find the ansi syntax difficult to read and format when
> inline views are present.
>
>

this is easily rectified by using query subfactoring (WITH clause) rather than
inline views.

I've never like inline views simply because they make the queries so much more difficult to understand.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

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

Received on Thu Dec 23 2010 - 11:38:09 CST