Home » SQL & PL/SQL » SQL & PL/SQL » IN Clause with 100 or more items (Oracle 11g)
IN Clause with 100 or more items [message #410125] Thu, 25 June 2009 06:59 Go to next message
satgur
Messages: 2
Registered: August 2006
Junior Member
I am using IN clause in query which have more than 100 items in it. Query is breaking up.
Any suggestions on how can I pull 100 or more items with the help of IN or any other statement in oracle ?

Thanks
Re: IN Clause with 100 or more items [message #410126 is a reply to message #410125] Thu, 25 June 2009 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can use 100 items or more in IN. The limit is 1000 (as far I remember).

Regards
Michel
Re: IN Clause with 100 or more items [message #410127 is a reply to message #410125] Thu, 25 June 2009 07:04 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
satgur wrote on Thu, 25 June 2009 06:59
Query is breaking up.



"Captn, she can't take much more!"
Re: IN Clause with 100 or more items [message #410128 is a reply to message #410126] Thu, 25 June 2009 07:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Correct...1000 is the limit (Expression Lists).
Re: IN Clause with 100 or more items [message #410141 is a reply to message #410127] Thu, 25 June 2009 08:00 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
smartin wrote on Thu, 25 June 2009 14:04
satgur wrote on Thu, 25 June 2009 06:59
Query is breaking up.



"Captn, she can't take much more!"




"Just reverse the polarity!!"
Previous Topic: what wrong here?
Next Topic: procedure error
Goto Forum:
  


Current Time: Tue Dec 06 08:36:18 CST 2016

Total time taken to generate the page: 0.12482 seconds