Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Max size of query?

Re: Max size of query?

From: Hallvard B Furuseth <h.b.furuseth_at_usit.uio.no>
Date: 10 Aug 2002 13:46:08 +0200
Message-ID: <HBF.20020810hybc@bombur.uio.no>


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.

> 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.

That said, I do hope to get rid of the code soon when the database is redesigned.

-- 
Hallvard
Received on Sat Aug 10 2002 - 06:46:08 CDT

Original text of this message

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