oracle高级查询.docVIP

高级查询： select * from more_employees t start with t.employee_id = 1connect by prior t.employee_id = t.manager_id EMPLOYEE_ID MANAGER_ID FIRST_NAME LAST_NAME TITLE SALARY 1 1 James Smith CEO 3.254E+10 2 2 1 James1 Smith1 CEO1 3.254E+10 3 3 2 James2 Smith2 CEO2 3.254E+10 4 5 2 James4 Smith4 CEO4 3.254E+10 5 4 1 James3 Smith3 CEO3 3.254E+10 6 6 4 James5 Smith5 CEO5 3.254E+10 7 9 6 James8 Smith8 CEO8 3.254E+10 8 7 4 James6 Smith6 CEO6 3.254E+10 9 8 7 James7 Smith7 CEO7 3.254E+10 10 10 1 James9 Smith9 CEO9 3.254E+10 说明： 定义employee_id=1表示查询从员工1 开始。Prior_condition表示子节点manager_id指向