Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> IN clause with more than 999 elements

IN clause with more than 999 elements

From: laSerpe <f_cerpelloni__at_hotmail.com>
Date: Wed, 17 Sep 2003 10:30:39 +0200
Message-ID: <bk963b$mpmvv$1@ID-122704.news.uni-berlin.de>


How can I solve problem which Oracle IN-clause doesn't work with more than 999 elements?
for example:
I want execute a query like:
SELECT * FROM TABLE WHERE FIELD IN (VALUE1,...VALUEn) with n>=1000 thank you, federica Received on Wed Sep 17 2003 - 03:30:39 CDT

Original text of this message

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