Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limit of 1050 columns for ANSI joins

Re: Limit of 1050 columns for ANSI joins

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 7 Jun 2006 10:08:03 -0700
Message-ID: <1149700083.799152.81830@h76g2000cwa.googlegroups.com>

Mark D Powell wrote:
> Mladen Gogala wrote:
> > On Wed, 07 Jun 2006 05:06:33 -0700, Andreas Sheriff wrote:
> >
> > > Yeah, yeah, so I have 1095 columns (For online surveys, those data points
> > > really add up, and this is a small survey...), that doesn't mean I should be
> > > limited, should I?
> > > Can anyone find a reference in the Oracle documentation that states 1050 as
> > > a column limit for ANSI joins? I see a 1000 column limit for tables, but it
> > > doesn't say anything about views or ANSI joins.
> >
> > Then don't use ANSI joins. Oracle has the corresponding syntax, which is
> > more logical and causes less problems with performance and optimization
> > then ANSI joins. Personally, I find ANSI joins clumsy and plain stupid.
> > ANSI joins provide the illusion that your SQL is, somehow, portable.
> > Oracle probably supported ANSI joins just because everybody else did, but
> > those monstrosities break the spirit of SQL. Tedd Codd probably died when
> > he saw ANSI join syntax being called SQL. SQL is a language that was
> > modeled after naive set theory, which means that it provides criteria for
> > selecting various elements from the given set. Unfortunately, developers
> > are somehow entranced by this idiotic construct and still prefer it over
> > the nice logical Oracle syntax.
> >
> > --
> > http://www.mgogala.com
>
> I thought the Oracle limit of 1000 columns in a table also applied to a
> view:

Maybe he doesn't think views are based on tables? Received on Wed Jun 07 2006 - 12:08:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US