RE: UNION operators

not that I am aware of -- until you reach the maximum size of a SQL statement.
sooner or later, you always hit some limitation -- in Oracle, this typically
happens
a long time after you should have done something else to improve your SQL :-)
kind regards,

Lex.
 
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Denys van Kempen
Sent: Tuesday, March 22, 2005 09:36
To: oracle-l@xxxxxxxxxxxxx
Subject: UNION operators

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: