sql语句:
select substr(sys_connect_by_path(name, '->'), 3) text, t.* from base_department t
start with id = 10001
connect by prior t.id = t.parent_id;
运行结果:
sql语句:
select substr(sys_connect_by_path(name, '->'), 3) text, t.* from base_department t
start with id = 10001
connect by prior t.id = t.parent_id;
运行结果: