oracle中 connect by prior 递归算法
select departcode from t_department start with departid = #departid # connect by prior departid=parentdepartid
start with 开始递归的位置
connect by prior 后为递归关系
where 后为递归过滤的条件
oracle中 connect by prior 递归算法
select departcode from t_department start with departid = #departid # connect by prior departid=parentdepartid
start with 开始递归的位置
connect by prior 后为递归关系
where 后为递归过滤的条件