oracle 取表字段,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 取多级的表字段

标签：and   ble   within   case   star   The   load   listagg   super

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/sx2zx/p/13225994.html