1. 生成树表全路径
SELECT WORKLOAD_KIND_TREE_ID, parent_ids
from (SELECT tt.WORKLOAD_KIND_TREE_ID,
TRIM(LEADING ',' FROM
SYS_CONNECT_BY_PATH(tt.WORKLOAD_KIND_TREE_ID, '/')) as parent_ids
from brc.tp_workload_kind_tree tt
START WITH tt.WORKLOAD_KIND_TREE_ID = '62'
CONNECT BY PRIOR tt.WORKLOAD_KIND_TREE_ID = tt.parent_id) t