Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.
ctcgag_at_hotmail.com wrote:
> 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?
Sorry but I have reservations.
>>How long did it take?
And your employer paid you for this? Anyone doing this on my dime would be looking for another job.
>>How many mistakes did you make?
Nonsense. Pure unadulterated nonsense.
>
>>Copied and pasted in a list of 20,000 items? Nonsense!
Given that it is impossible to do this in Oracle how did you accomplish it?
>>But the simple solution as I previously posted: >> >>SELECT * >>FROM mytable >>WHERE MOD(id, 2) = 1 >>AND id < 20001;
No assumptions ... I read the SQL statement provided by the OP.
Daniel Morgan Received on Tue Jul 13 2004 - 19:34:24 CDT