---递归查询(注意prior的位置)
SELECT job_no,condition_no FROM analysis_job.t_job_plan t START WITH job_no=100 CONNECT BY condition_no= PRIOR job_no
SELECT job_no,condition_no FROM analysis_job.t_job_plan t START WITH job_no=100 CONNECT BY condition_no= PRIOR job_no
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28291944/viewspace-2143725/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28291944/viewspace-2143725/