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