RE: UNION operators

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 22 Mar 2005 10:36:04 +0100
Message-Id: <20050322093607.B8D7FB000DBD@smtp-out2.tiscali.nl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Denys van Kempen
Sent: Tuesday, March 22, 2005 09:36
To: oracle-l_at_freelists.org
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 Received on Tue Mar 22 2005 - 04:39:47 CST