【Oracle】使用PL/SQL快速查询出1-9数字
简单来说，直接Recursive WITH Clauses
在Oracle 里面就直接使用WITH result(参数)即可
WITH result(num) AS
(SELECT 1 AS num from dual
UNION ALL
SELECT num + 1 AS num
FROM result
WHERE num < 9)
SELECT num FROM result
结果如下
简单来说，直接Recursive WITH Clauses
在Oracle 里面就直接使用WITH result(参数)即可
WITH result(num) AS
(SELECT 1 AS num from dual
UNION ALL
SELECT num + 1 AS num
FROM result
WHERE num < 9)
SELECT num FROM result
结果如下