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

Home -> Community -> Usenet -> c.d.o.server -> Very long "WHERE" list.

Very long "WHERE" list.

From: Serguei <gumenyuk_at_canada.com>
Date: 8 Jul 2004 09:42:01 -0700
Message-ID: <c1e8f29a.0407080842.557330e1@posting.google.com> 





Dear Experts,


I have to execute a SELECT statement with a very long "IN" list with
several thousands of values:



SELECT something FROM table WHERE id IN (1,3,5, ...., 20001)



Unfortunately Oracle can not process this request directly. Is there
any way to by path this limitation?


  Regards,


    Serguei.
Received on Thu Jul 08 2004 - 11:42:01 CDT












Original text of this message













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