图片是目录结构式数据查询,用到树查询start with以及列转行操作
代码如下
select replace(wm_concat(dmmc),',','/')from (select dmmc from GG_DMNR start with id=(select CGFL from XM_YSMX where id =:id)connect by prior fid=id order by id)
图片是目录结构式数据查询,用到树查询start with以及列转行操作
代码如下
select replace(wm_concat(dmmc),',','/')from (select dmmc from GG_DMNR start with id=(select CGFL from XM_YSMX where id =:id)connect by prior fid=id order by id)