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
