Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.
Daniel Morgan <damorgan_at_x.washington.edu> wrote:
> >
> > Or, #4, the client copies and pastes the list from some other source.
> >
>
> Have you ever typed in 20,000 anythings?
Yep.
> How long did it take?
A few days.
> How many mistakes did you make?
None.
> Copied and pasted in a list of 20,000 items? Nonsense!
I've done it twice so far today, and it is only 8:14 a.m.
>
> But the simple solution as I previously posted:
>
> SELECT *
> FROM mytable
> WHERE MOD(id, 2) = 1
> AND id < 20001;
That is the simple solution only if you assume an aweful lot about the content of the OPs ellipsis.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Tue Jul 13 2004 - 10:20:58 CDT