Oracle树查询例子

树查询

SELECT u.id FROM t_unit u START WITH u.id = '1' CONNECT BY PRIOR u.id = u.parentid;