Re: Max size of query?

Comments interspersed below:

Hallvard B Furuseth wrote:

> Daniel Morgan <dmorgan_at_exesolutions.com> writes:
>
> > I believe that this list size is unlimited except by the common sense of
> > the person banging out the code. For example I would never write what
> > you have done above. Rather I would do this:
> >
> > SELECT ...
> > FROM ...
> > WHERE uname IN (
> > SELECT uname
> > FROM some_other table);
>
> Then I'd have to insert these user names in a table first.

They are already there or you couldn't find them could you? But yes you would. However if it is a large enough number of names that you are concerned about how many Oracle can handle how long will it take you to type them into your IN statement vs how long to put them into a table? The same amount of time. And yet in one case you can only use them once and in the other case you can reuse them forever.

> > Hard coded values are a maintenance nightmare and in cases such as you
> > seem to be describing, above, have little if any place in a relational
> > database.
>
> They are not hardcoded, they are generated. A different list each time.

From where?

> That said, I do hope to get rid of the code first when the database is
> redesigned.
>
> --
> Hallvard

A great idea.

Daniel Morgan Received on Sun Aug 11 2002 - 09:16:45 CDT