http://www.ztree.me/v3/demo.php#_114
http://blog.sina.com.cn/s/blog_829c226e010117rj.html
SELECT T.*
FROM SYS_DM T
START WITH (T.DMBM = 'CMO_OFFICE_JOB')
CONNECT BY PRIOR T.ID = T.PID
http://www.ztree.me/v3/demo.php#_114
http://blog.sina.com.cn/s/blog_829c226e010117rj.html
SELECT T.*
FROM SYS_DM T
START WITH (T.DMBM = 'CMO_OFFICE_JOB')
CONNECT BY PRIOR T.ID = T.PID
转载于:https://www.cnblogs.com/wshsdlau/archive/2012/06/26/2563725.html