Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limit of 1050 columns for ANSI joins
"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message
news:4IFhg.133387$F_3.37189_at_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
Keep on topic. No views (no pun intended) about politically incorrect marriages, please.
This is about Oracle. 'Not about how happy an individual wants to be.
-- Andreas Sheriff Oracle 9i Certified Professional Oracle 10g Certified Professional Oracle 9i Certified PL/SQL Developer ---- "If you don't eat your meat, you cannot have any pudding. "How can you have any pudding, if you don't eat your meat?" DO NOT REPLY TO THIS EMAIL Reply only to the group.Received on Wed Jun 07 2006 - 14:30:57 CDT