OraFAQ Forum: SQL & PL/SQL » IN Clause with 100 or more items

Home » SQL & PL/SQL » SQL & PL/SQL » IN Clause with 100 or more items (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IN Clause with 100 or more items [message #410125]

Thu, 25 June 2009 06:59

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

Report message to a moderator

Re: IN Clause with 100 or more items [message #410126 is a reply to message #410125]

Thu, 25 June 2009 07:02

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can use 100 items or more in IN. The limit is 1000 (as far I remember).

Regards
Michel

Report message to a moderator

Re: IN Clause with 100 or more items [message #410127 is a reply to message #410125]

Thu, 25 June 2009 07:04

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!"

Report message to a moderator

Re: IN Clause with 100 or more items [message #410128 is a reply to message #410126]

Thu, 25 June 2009 07:17

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Correct...1000 is the limit (Expression Lists).

Report message to a moderator

Re: IN Clause with 100 or more items [message #410141 is a reply to message #410127]

Thu, 25 June 2009 08:00

ThomasG
Messages: 3212
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!!"

Report message to a moderator

Previous Topic:	what wrong here?
Next Topic:	procedure error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 14:14:15 CST 2025