select substr(sys_connect_by_path(t1.agency, ''','''),3)||''''
from (select t.agency, rownum as row_id,rownum-1 as p_id from foreign_agency t) t1
where t1.row_id=1 /*递归的起点*/
start with t1.row_id = (select count(*) from foreign_agency) /*递归的终点*/
connect by t1.row_id = prior t1.p_id
from (select t.agency, rownum as row_id,rownum-1 as p_id from foreign_agency t) t1
where t1.row_id=1 /*递归的起点*/
start with t1.row_id = (select count(*) from foreign_agency) /*递归的终点*/
connect by t1.row_id = prior t1.p_id
扫一扫
3552
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
