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 -> Re: Very long "WHERE" list.

Re: Very long "WHERE" list.

From: <ctcgag_at_hotmail.com>
Date: 13 Jul 2004 15:20:58 GMT
Message-ID: <20040713112058.743$ZG@newsreader.com>


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 30GB
Received on Tue Jul 13 2004 - 10:20:58 CDT

Original text of this message

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