Home » SQL & PL/SQL » SQL & PL/SQL » ‘in’ clause
‘in’ clause [message #382122] Wed, 21 January 2009 01:04 Go to next message
sachinkkhot
Messages: 8
Registered: January 2009
Junior Member
Is there any limitation of ‘in’ clause?
Re: ‘in’ clause [message #382130 is a reply to message #382122] Wed, 21 January 2009 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, 2000 elements (or less depending on your version).
And of course SQL statement size limit.

Regards
Michel

[Updated on: Wed, 21 January 2009 01:26]

Report message to a moderator

Re: ‘in’ clause [message #382137 is a reply to message #382130] Wed, 21 January 2009 01:52 Go to previous messageGo to next message
sachinkkhot
Messages: 8
Registered: January 2009
Junior Member
is posible for you to provide version wise list?

thanks and regards,
Sachin
Re: ‘in’ clause [message #382138 is a reply to message #382137] Wed, 21 January 2009 01:54 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you have to search in each SQL Reference: http://tahiti.oracle.com

Regards
Michel
Previous Topic: Retreiveing data from two tables (Merged)
Next Topic: Mutuating Trigger
Goto Forum:
  


Current Time: Fri Dec 02 12:37:50 CST 2016

Total time taken to generate the page: 0.05404 seconds