1、oracle简单的游标遍历
--游标
DECLARE
cursor cur is--定义一个游标
SELECT * FROM sys_org START WITH id ='88a9bed0f9d5bc882e9140feb8f3cfa1' CONNECT BY org_parent_id = PRIOR id;
BEGIN
FOR x IN cur LOOP--循环游标
dbms_output.put_line(x.id);
END LOOP;
END;
2、执行结果: