如何在Oracle层次查询中给SIBLINGS排序

开发者在线 Builder.com.cn 更新时间:2007-01-22作者:builder.com.cn 来源:

column "Reports To" format a30
set pagesize 9999

SELECT LPAD(' ', 2*(LEVEL-1))||last_name "Reports To", employee_id
FROM employees
START WITH employee_id IN (101, 102)
CONNECT BY PRIOR employee_id = manager_id
/

用户评论

  • 用户名
  • 评论内容