Re: UNION operators

A 7000-fold UNION worked on my 9.2.0.5 database (Linux).
The following ksh script (apologies Jared) will help you to find the
limit:

max=1000
while :
do
  count=0
  {
    echo "select $max from dual"
    while [ $count -lt $max ]
    do
      count=`expr $count + 1`
      echo "UNION"
      echo "select $max from dual"
    done
    echo "/"
    echo exit
  } | sqlplus 'scott/tiger'
  max=`expr $max + 1000`
done

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===

On Tue, 2005-03-22 at 09:35, Denys van Kempen 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




--
http://www.freelists.org/webpage/oracle-l

Other related posts: