Re: UNION operators

Here's some perl to generate a 20001 way union.

The SQL is still parsing on my test box.

perl -e "print qq{select 1 from dual\nunion\n} x 20000 . q{select 1
from dual;}" >| utest.sql

It worked easily up to about 3000 way union.

Jared


On Tue, 22 Mar 2005 09:35:52 +0100, Denys van Kempen <dvkempen@xxxxxxxxx> wrote:
> Does anybody know if there is a limit to the number of UNION operators
> allowed in a SELECT?
> 
> Could not find any mention of an upper limit in the documentation or
> issues with queries using a large number of operator in Metalink.
> 
> Thanks,
> 
> Denys
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Other related posts: