WITH
params AS(SELECT 10 upperlimit FROM DUAL),
x (n)
AS
(SELECT 1 n FROM DUAL
UNION ALL
SELECT n + 1 n
FROM x , params
WHERE n < upperlimit)
SELECT *
FROM x| N | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|
WITH
params AS(SELECT 10 upperlimit FROM DUAL),
x (n)
AS
(SELECT 1 n FROM DUAL
UNION ALL
SELECT n + 1 n
FROM x cross join params
WHERE n < upperlimit)
SELECT *
FROM xORA-32044: cycle detected while executing recursive WITH queryMore Details: https://docs.oracle.com/error-help/db/ora-32044