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