java tree.left oracle_oracle实现Tree

select a.*,level from t_customer a

start with customer_id = 'AABB10000010'

connect by prior customer_id = parent_cust_id

select a.*, level

from t_industry a

start with industry_id  = 'B03'

connect by prior industry_id = parent_id

--connect String

select Substr('bbbcbdb',1,2) ||replace(Substr('bbbcbdb',3,4),'b','a') ||Substr('bbbcbdb',7,1) from dual

select Replace(customer_name, '->','') as all_customer_name,rownum from (

select sys_connect_by_path(customer_name, '->') customer_name from (

select a.customer_name, (level - 1) ll,level l

from t_customer a

start with customer_id = 'SH02110000893' connect by prior parent_cust_id=customer_id order by l desc

)

connect by prior ll= l order by level desc

) c where rownum <2

根据字节点查出全名

with temp as(

select a.*, (level - 1) ll, level l

from t_content_type a

start with a.type_id = '20000000138418'

connect by prior a.parent_type_id = a.type_id

order by l desc

)

select sys_connect_by_path(temp.type_name, '/') path

from temp

start with temp.parent_type_id = '0'

connect by prior temp.type_id = temp.parent_type_id