MERGE INTO tt_secu_orgs p
USING (select id, level as c_level
, substr(sys_connect_by_path(id,'-')||'-',2) nest_path
from tt_secu_orgs
start with id = 1
connect by nocycle prior id = parent_id) np
ON (p.id = np.id)
WHEN MATCHED THEN
UPDATE SET p.current_level = np.c_level, p.org_str = np.nest_path;
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。