利用分析函数生成连续数据

WITH cat AS
    (
    select '1000' ID, '1010'+1 PID FROM dual union
    SELECT '1011' ID, '1050'+1 PID FROM dual UNION
    SELECT '1051' ID, '1056'+1 PID FROM dual UNION
    SELECT '1059' ID, '1072'+1 PID FROM dual UNION
    SELECT '1200' ID, '1210'+1 PID FROM dual UNION
    SELECT '1211' ID, '1240'+1 PID FROM dual UNION
    SELECT '1501' ID, '1570'+1 PID FROM dual UNION
    SELECT '1571' ID, '1580'+1 PID FROM dual UNION
    SELECT '1581' ID, '1600'+1 PID FROM dual 
    ),
    xx AS (
    SELECT ID,pid,LAG(pID) OVER (ORDER BY ID) AS new_id FROM cat
    ),
    yy AS (
    SELECT ID,pid,new_id,CASE WHEN id = nvl(new_id,pid) THEN 0 ELSE 1 END AS group_id FROM xx
    ),
    xy AS (
    SELECT ID,pid,new_id,SUM(group_id)OVER(ORDER BY ID) AS g_ri FROM yy  
    )
    --SELECT * FROM xy
    SELECT MIN(ID) AS ID,MAX(pid) - 1 AS pid FROM xy GROUP BY g_ri ORDER BY g_ri;