oracle查询父子关系语句

SELECT
*
FROM
(
SELECT
*
FROM
SYS_ORG START WITH org_id =1 CONNECT BY PRIOR org_id = PARENT_ID ORDER SIBLINGS BY
org_sort )
WHERE
delete_flag = 0

oracle查询父子关系语句

标签：where   select   sys   sort   parent   lin   star   rom   delete