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
CONNECT BY PRIOR rd.dept_id=rd.upper_dept_id
START WITH rd.upper_dept_id IS NULL