当前位置：首页 > 数据库 > 正文

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