SELECT
Id,
parentId,
FROM
TableName START WITH Id= '02' Connect BY Prior Id= parentId
字段名-子ID:Id
字段名-父ID:parentId
START WITH:从哪一代开始查找,它的ID是什么?将参数写入条件
CONNECT BY PRIOR:关联的2个字段名
详见代码
SELECT
Id,
parentId,
FROM
TableName START WITH Id= '02' Connect BY Prior Id= parentId
字段名-子ID:Id
字段名-父ID:parentId
START WITH:从哪一代开始查找,它的ID是什么?将参数写入条件
CONNECT BY PRIOR:关联的2个字段名
详见代码