|
|
Posted by Roy Harvey on 10/02/41 11:54
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
Navigation:
[Reply to this message]
|