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: Bagieta <user_at_example.net>
Date: Wed, 23 Feb 2005 18:21:14 +0100
Message-ID: <cvidha$huh$1@news.onet.pl>


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.

-- 
Best regards
Bagieta

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
www.dbdeveloper.prominentus.com a tool for Oracle developers 30 days trial
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Wed Feb 23 2005 - 11:21:14 CST

Original text of this message

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