Java Developer Forum / Java (General) / JDBC / Oracel SQL "IN" Clause Problem

Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracel SQL "IN" Clause Problem
11-30-2009, 05:47 PM (This post was last modified: 11-30-2009 05:49 PM by arun.)
Post: #1
arun Offline
Junior Member
**
 		Posts: 10
Joined: Jun 2007
Reputation: 0
Oracel SQL "IN" Clause Problem
hi

Is there any way to get around the Oracle 10g limitation of 1000 items in a static IN clause?
I have a comma delimited list of many of IDs that I want to use in an IN clause, Sometimes this list can exceed 1000 items, at which point Oracle throws an error

ex
Code:
select * from table1 where ID in (1,2,3,4,...,1001,1002,...)
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


Contact Us | Java Developer Resource | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication