WITH T1 AS
(SELECT 1 ID, 2 NUM FROM DUAL
UNION ALL
SELECT 2 ID, 4 NUM FROM DUAL)
SELECT T1.*,LEVEL
FROM T1
CONNECT BY PRIOR ID = ID
AND LEVEL <= T1.NUM
AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL;
获取区间内的明细数据:如图WITH T1 AS (SELECT 1 ID, 2 NUM FROM DUAL UNION ALL SELECT 2 ID, 4 NUM FROM DUAL)SELECT T1.*,LEVEL FROM T1CONNECT BY PRIOR ID = ID AND LEVEL &lt;= T1.NUM AND PRIOR DBMS_RAND...