| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Limit to number of items in a List [WHERE id IN (,,,,)]
Craig B. wrote:
> 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.
Yes. At a certain point a subquery will be easier to write, maintain and code.
-- Regards, Frank van BortelReceived on Tue Mar 02 2004 - 14:28:47 CST
![]() |
![]() |