Re: UNION operators
- From: Jared Still <jkstill@xxxxxxxxx>
- To: dvkempen@xxxxxxxxx
- Date: Tue, 22 Mar 2005 15:42:00 -0800
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
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
