Limit to number of items in a List [WHERE id IN (,,,,)]

From: Craig B. <craig.bender_at_practiceone.com>
Date: 2 Mar 2004 12:14:35 -0800
Message-ID: <6a45b902.0403021214.68b7ff8c_at_posting.google.com>

Does any know if there is a limitation on the number of items you can contain within an SQL list. (e.g. WHERE id IN (,,,,) ). And if that differs from having a sub-query oppose to literal values?

Regards,
Craig. Received on Tue Mar 02 2004 - 21:14:35 CET

This message: [ Message body ]
Next message: Mark C. Stock: "Re: iSQL*Plus bug with substitution variable?! (9.2.0.1.0)"
Previous message: Peter Hitchmough: "What is the bottom line on Oracle layout on Virtual Arrays?"
Next in thread: Frank van Bortel: "Re: Limit to number of items in a List [WHERE id IN (,,,,)]"
Reply: Frank van Bortel: "Re: Limit to number of items in a List [WHERE id IN (,,,,)]"
Reply: charely: "Re: Limit to number of items in a List [WHERE id IN (,,,,)]"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message