set serveroutput on; --只有开启的情况下才能在控制台输出结果
declare
CURSOR org_cur IS
select id,org_name from eom.t_sys_organization where pid=2 and deleted='N' ;
total number(10);
BEGIN
FOR org_row IN org_cur
LOOP
select max(level_num) into total from (
select level as level_num,m.org_name from eom.t_sys_organization m where m.deleted = 'N' start with m.id=org_row.id connect by m.pid=prior m.id);
DBMS_OUTPUT.PUT_LINE('所属机构:' || org_row.org_name ||',层级数:'|| total) ;
END LOOP;
END;
/
Oracle--创建执行过程
最新推荐文章于 2024-07-03 14:18:25 发布