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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 07 Jun 2006 19:22:40 GMT
Message-ID: <4IFhg.133387$F_3.37189@newssvr29.news.prodigy.net>


Mark D Powell wrote:

>
> I thought the Oracle limit of 1000 columns in a table also applied to a
> view:
>

>>From 9.2 SQL manual >>

> AS subquery
> Specify a subquery that identifies columns and rows of the table(s)
> that the view is based on. The select list of the subquery can contain
> up to 1000 expressions.

I wasn't paying attention to the part about views. I am waging jihad against ANSI joins(TM). They should be banned, together with some politically incorrect forms of marriage. I can live with $3.20/gallon but ANSI joins really get me.

-- 
Mladen Gogala
http://www.mgogala.com
Received on Wed Jun 07 2006 - 14:22:40 CDT

Original text of this message

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