oracle start with connect by base_pd_clazz

select lpad('test',10) from dual;
将返回“ test”

select lpad('test',10,'ee') from dual;
结果将返回eeeeeetest。

create or replace view base_pd_clazz as
select t.cls_id,
       t.cls_name,
       LPAD('|-', (level - 1) * 4, '　| ') || LPAD('『', 2) || t.cls_name ||
       RPAD('』', 2) tree_name,
       CONNECT_BY_ISLEAF IS_LEAF,
       level CLS_LEVEL,
       t.par_id,
       t1.cls_name par_name,
       t.root_id,
       t2.cls_name root_name,
       ltrim(sys_connect_by_path(t.cls_name, ','), ',') FULL_NAME,
       t.order_value,
       t.is_del
  from base_pd_class t
  left join base_pd_class t1 on t.par_id = t1.cls_id
  left join base_pd_class t2 on t.root_id = t2.cls_id
 start with t.par_id = -1
connect by prior t.cls_id = t.par_id;

SELECT
    'public static final Integer PRE_' || item_cd || ' = ' || item_cd || '; // '|| item_nm
FROM
    table article_mod
ORDER BY
    item_cd

[color=red]
start with 和 where条件一起时候时，放在where条件的最后面并且没有and
[/color]

<isNotEmpty prepend="  " property="map.level_3_start_with_not_in">
			start with a.CLS_LEVEL = 3 and a.cls_id not in 
			<iterate close=")" open="(" conjunction="," property="map.level_3_start_with_not_in">#map.level_3_start_with_not_in[]#</iterate>
			connect by prior cls_id = par_id
		</isNotEmpty>