您可以使用带有SEARCH子句的递归查询来模拟带有ORDER SIBLINGS BY的分层查询：

WITH emps (last_name, employee_id, manager_id, depth) AS (
  SELECT last_name, employee_id, manager_id, 1
  FROM   employees
  WHERE  employee_id = 100
UNION ALL
  SELECT e.last_name, e.employee_id, e.manager_id, p.depth + 1
  FROM   employees e
         INNER JOIN emps p
         ON p.employee_id = e.manager_id
)
SEARCH DEPTH FIRST BY last_name SET order_id
SELECT last_name, employee_id, manager_id, depth
FROM   emps;

字符串
其中，对于样本数据：

CREATE TABLE employees (last_name, employee_id, manager_id) AS
SELECT 'Alice', 100, NULL FROM DUAL UNION ALL
SELECT 'Beryl', 101, 100 FROM DUAL UNION ALL
SELECT 'Carol', 102, 100 FROM DUAL UNION ALL
SELECT 'Debra', 103, 100 FROM DUAL UNION ALL
SELECT 'Emily', 104, 101 FROM DUAL UNION ALL
SELECT 'Fiona', 105, 104 FROM DUAL UNION ALL
SELECT 'Gerri', 106, 102 FROM DUAL UNION ALL
SELECT 'Holly', 107, 102 FROM DUAL UNION ALL
SELECT 'Irene', 108, 107 FROM DUAL UNION ALL
SELECT 'Julia', 109, 106 FROM DUAL UNION ALL
SELECT 'Kerry', 110, 104 FROM DUAL;

型
输出：
| 员工_ID|管理员ID|深度| DEPTH |
| --|--|--| ------------ |
| 一百| * 空 *| 一个| 1 |
| 一百零一|一百|二个| 2 |
| 一百零四|一百零一|三个| 3 |
| 一百零五|一百零四|四个| 4 |
| 一百一十|一百零四|四个| 4 |
| 一百零二|一百|二个| 2 |
| 一百零六|一百零二|三个| 3 |
| 一百零九|一百零六|四个| 4 |
| 一百零七|一百零二|三个| 3 |
| 一百零八|一百零七|四个| 4 |
| 一百零三|一百|二个| 2 |
fiddle