日期:2014-05-16 浏览次数:20685 次
select t_department.*, sys_connect_by_path(depname, '/') as path from t_department start with parentid=-1 connect by prior id=parentid;