WITH one AS (select 1 one_col1, 10 one_col2 from dual), ones_next AS (select one_col1 + 1 from one) select * from ones_next;
・CONNECT BY
SELECT employee_id, last_name, manager_id FROM employees CONNECT BY PRIOR employee_id = manager_id;
・START WITH ~ ORDER SIBLINGS BY
SELECT last_name, employee_id, manager_id, LEVEL FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY last_name
・WITH
WITH one AS (select 1 one_col1, 10 one_col2 from dual), ones_next AS (select one_col1 + 1 from one) select * from ones_next;
・CONNECT BY
SELECT employee_id, last_name, manager_id FROM employees CONNECT BY PRIOR employee_id = manager_id;
・START WITH ~ ORDER SIBLINGS BY
SELECT last_name, employee_id, manager_id, LEVEL FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY last_name