Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Max size of query?
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.
-- HallvardReceived on Sat Aug 10 2002 - 06:46:08 CDT