column "Reports To" format a30set pagesize 9999SELECT LPAD(' ', 2*(LEVEL-1))||last_name "Reports To", employee_idFROM employeesSTART WITH employee_id IN (101, 102)CONNECT BY PRIOR employee_id = manager_id/

ORDER SIBLINGS BY <expression>

ORDER SIBLINGS BY last_name

SQL> @siblings_without_orderbyReports To                     EMPLOYEE_ID                                      ------------------------------ -----------                                      Kochhar                            101                                      Whalen                             200                                      Mavris                             203                                      Baer                               204                                      Higgins                            205                                      Gietz                              206                                      Greenberg                          108                                      Faviet                             109                                      Chen                               110                                      Sciarra                            111                                      Urman                              112                                      Popp                               113                                      De Haan                            102                                      Hunold                             103                                      Ernst                              104                                      Austin                             105                                      Pataballa                          106                                      Lorentz                            107                                      18 rows selected.SQL> @siblings_with_orderbyReports To                     EMPLOYEE_ID                                      ------------------------------ -----------                                      De Haan                            102                                      Hunold                             103                                      Austin                             105                                      Ernst                              104                                      Lorentz                            107                                      Pataballa                          106                                      Kochhar                            101                                      Baer                               204                                      Greenberg                          108                                      Chen                               110                                      Faviet                             109                                      Popp                               113                                      Sciarra                            111                                      Urman                              112                                      Higgins                            205                                      Gietz                              206                                      Mavris                             203                                      Whalen                             200                                      18 rows selected.SQL>