可能一个查询语句是完成不了你这个东西了。
DECLARE
CURSOR V_CURSOR IS
SELECT * FROM TABLE_TEST;
V_COUNT NUMBER;
BEGIN
FOR C1 IN V_CURSOR LOOP
SELECT COUNT(1)
INTO V_COUNT
FROM TABLE_TEST A
START WITH A.ID = C1.ID
CONNECT BY PRIOR A.ID = A.PID;
DBMS_OUTPUT.PUT_LINE(C1.NAME || ',' || V_COUNT);
END LOOP;
END;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024