Recursive query of Oracle PL/SQL-CONNECT BY PRIOR

Recursive query of Oracle PL/SQL-CONNECT BY PRIOR:

1. Duzz $ scott @ orcl>SELECTEmployee_id, last_name, job_id, manager_id
2. 2FROMEmployees
3. 3 STARTWITHMaid = 101
4. 4CONNECT BY PRIOREmployee_id = manager_id;
5. (PRIOR: Previous, with priority; perform recursive queries based on the previous employee_id that is equal to the row's manager_id, from top to bottom)
6. EMPLOYEE_ID LAST_NAME JOB_ID MANAGER_ID
7. ----------------------------------------------------------------------------
8. 101 Kochhar AD_VP 100
9. 108 Greenberg FI_MGR 101
10. 109 Faviet FI_ACCOUNT 108
11. 110 Chen FI_ACCOUNT 108
12. 111 Sciarra FI_ACCOUNT 108
13. 112 Urman FI_ACCOUNT 108
14. 113 Popp FI_ACCOUNT 108
15. 200 Whalen AD_ASST 101
16. 203 Mavris HR_REP 101
17. 204 Baer PR_REP 101
18. 205 Higgins AC_MGR 101
19. 206 Gietz AC_ACCOUNT 205
21. 12RowsSelected.
23. Elapsed: 00:00:00. 03
24. Duzz $ scott @ orcl>SELECTEmployee_id, last_name, job_id, manager_id
25. 2FROMEmployees
26. 3 STARTWITHMaid = 101
27. 4CONNECT BYEmployee_id =PRIORManager_id;
28. (Take the previous manager_id (employee_id = 101) as the current employee_id, from bottom to top)
29. EMPLOYEE_ID LAST_NAME JOB_ID MANAGER_ID
30. ----------------------------------------------------------------------------
31. 101 Kochhar AD_VP 100
32. 100 King AD_PRES
34. Elapsed: 00:00:00. 00