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