oracle 取多级的表字段

select case superguid when '0' then name else (select LISTAGG(name,'.') WITHIN GROUP(ORDER BY levelno) from busfw_t_dchead where tablecode = 'BDM_T_HC2232002019'
start with guid = a.guid
connect by prior superguid = guid) end name from busfw_t_dchead a where tablecode = 'BDM_T_HC2232002019' and isleaf = 1

 

 

oracle 取多级的表字段

 

上一篇:php 生成唯一编码函数


下一篇:【UEFI】---BIOS中对Guid的使用以及Lib函数的使用总结