|Subject:||Limitations in a query !!|
|Date:||2 Aug 2006|
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)".
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
Plz help me !!
Thanx in advance.