ORACLE常用数据查询

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