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

Home -> Community -> Usenet -> c.d.o.misc -> Re: "select in" statment returns wrong number of rows

Re: "select in" statment returns wrong number of rows

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 23 Feb 2005 13:32:23 -0600
Message-ID: <1109186838.079403491fe8f56017117c6517a6d9ac@teranews>


Bagieta <user_at_example.net> wrote:

>There is also a trouble when you have 'in (...)' clause with more than
>1000 elements. In that case the oracle will show you an error.
>So there must be some problem with 'in' clause and I use it carefully.

an IN clause with that many elements is usually indicative of a bad design decision somewhere... Received on Wed Feb 23 2005 - 13:32:23 CST

Original text of this message

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