Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: fitzjarrell@cox.net
Newsgroups: comp.databases.oracle.server
Subject: Re: Maximun number of unions in a single query
Date: 6 Jun 2005 15:09:40 -0700
Organization: http://groups.google.com
Lines: 37
Message-ID: <1118095780.696653.153730@o13g2000cwo.googlegroups.com>
References: <9H3pe.5904$tr.1735@fed1read03>
NNTP-Posting-Host: 68.95.47.225
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118095786 21739 127.0.0.1 (6 Jun 2005 22:09:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Jun 2005 22:09:46 +0000 (UTC)
In-Reply-To: <9H3pe.5904$tr.1735@fed1read03>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=68.95.47.225;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244391



Andreas Sheriff wrote:
> Does anyone know the maximum number of unions you can use in a SQL query?
>
> For example:
>
> select 1 from dual union all
> select 2 from dual union all
> select 3 from dual union all
> ...
> select [x-2] from dual union all
> select [x-1] from dual union all
> select [x] from dual;
>
> What is the upper limit of x?
>
> --
> Andreas
> Oracle Certified DBA and PL/SQL Developer
>
> "If you don't eat your meat, you cannot have any pudding.
> "How can you have any pudding if you don't eat your meat?!?!"
> ---
>
> WARNING:
> DO NOT REPLY TO THIS EMAIL
> Reply to me only on this newsgroup

I believe it's not a limit of 'x' so much as a limit of how many
characters one can put in a sql ststement, which, according to the
documentation is 64K.  Of course you could always experiment and share
your results.


David Fitzjarrell