摘要: duzz$scott@orcl>SELECT employee_id, last_name, job_id, manager_id 2 FROM employees 3 START WITH employee_id = 101 4 CONNECT BY PRIOR employee_id=manager_id; (PRIOR:先前的,优先的;按照先前的employee_id等于本行的manager_id进行递归查询,从上至下) EMPLOYEE_ID LAST_NAME JOB_ID MANAGER_ID ---... 阅读全文
posted @ 2011-08-20 19:18 生活不是用来挥霍的 阅读(315) 评论(0) 推荐(0)