Posted by harsha.21aug on 10/05/60 11:54

Thanx alot Roy. :)

Roy Harvey wrote:
> On 2 Aug 2006 05:31:03 -0700, harsha.21aug@gmail.com wrote:
>
> >Hi all there,
> > I'm a newbee to this forum. I've a question, is there any limitation
> >on "IN" clause in select query.
> >for example :
> >"SELECT EMP_ID, EMP_NAME FROM EMPLOYEE WHERE EMP_ID IN
> >('EMP1001','EMP1002','EMP1003', etc, etc, so on)".
>
> There doesn't seem to be a documented limit, but if the list gets too
> long it should be in a table, not in-line code.
>
> >I've read at some documentation that there is a limitation for Columns
> >in a table and i.e. we can have only 1024 columns per table, is this
> >true?
>
> Yes, the limit is 1024 columns in a table. Any database design that
> comes close to this, much less needs to exceed it, is probably
> questionable.
>
> >Plz help me !!
> >
> >Thanx in advance.
> >
> >Kind Regards,
> >Harry
>
> Roy Harvey
> Beacon Falls, CT

[Back to original message]