Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Limit to number of items in a List [WHERE id IN (,,,,)]

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

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 02 Mar 2004 21:28:47 +0100
Message-ID: <c22qmq$dkm$1@news4.tilbu1.nb.home.nl>

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 Bortel
Received on Tue Mar 02 2004 - 14:28:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US