oracle的树形展示SELECT lpad(dept_name,length(dept_name)+(LEVEL*8)-1,.) FROM dc_department_test rd
oracle的树形展示
SELECT lpad(dept_name,length(dept_name)+(LEVEL*8)-1,'.') FROM dc_department_test rd
CONNECT BY PRIOR rd.dept_id=rd.upper_dept_id
START WITH rd.upper_dept_id IS NULL