有兴趣的同学可以保存一份
//json文件的第一层ca31Array1
SELECT ‘{“label”:"’||LABEL||’",“id”:"’||ID||’",“haschild”:"’||haschild || ‘"},’ FROM (SELECT LEVEL lv, T.*
FROM CA11 T
START WITH PARENTID = ‘0000000’
CONNECT BY PRIOR ID = PARENTID
ORDER SIBLINGS BY ID) WHERE lv = ‘1’
//Json文件的以后三层ca31Array2~ca31Array4,lv = '2’条件换成3和4
SELECT ‘{“label”:"’ || LABEL || ‘",“id”:"’ || ID || ‘",“haschild”:"’ ||
HASCHILD || ‘",“parent”:"’ || PARENTID || ‘"},’ FROM (SELECT LEVEL lv, T.*
FROM CA11 T
START WITH PARENTID = ‘0000000’
CONNECT BY PRIOR ID = PARENTID
ORDER SIBLINGS BY ID) WHERE lv = ‘2’