Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.
Galen Boyer <galenboyer_at_hotpop.com> wrote:
> On Mon, 12 Jul 2004, damorgan_at_x.washington.edu wrote:
>
> > Two choices:
> >
> > 1. The list is fixed and hard-coded into PL/SQL. If this is the
> > case any change to the list requires modifying source code
> > and running through a full QA cycle.
> >
> > 2. The list is being typed in by hand every time
What do you mean every time? How often does it have to be done for it to be an issue? What if it is normally used with 1 to 15 items, and once in a blue moon someone wants 20,000?
> > it is executed
> > in which case it will take the average worker many hours
> > not to mention the proofing.
>
> Or, #3, (as Jonathan nicely laid out), the client is a machine.
Or, #4, the client copies and pastes the list from some other source.
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Mon Jul 12 2004 - 12:25:44 CDT
![]() |
![]() |