ORACLE 递归练习

1.通过递归生成一个1～10的数字序列：

 

WITH t(n) AS (
SELECT 1 FROM dual
UNION ALL
SELECT n+1 FROM t WHERE n < 10
)
SELECT * FROM t