Maximun number of unions in a single query

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