start with connect by prior µÝ¹é²éѯÓ÷¨(¶þ)
ͻ񻣼
ÏÈÓÃscottÓû§ÏµÄemp±í×öʵÑé.emp±íÓиö×ֶΣ¬Ò»¸öÊÇempno(Ô±¹¤±àºÅ)£¬ÁíÒ»¸öÊÇmgr(Éϼ¶¾Àí±àºÅ)ÏÂÃæÊDZíÖÐËùÓÐÊý¾Ý 1 select * from emp start with empno=7698 connect by mgr=prior empno; Ö´Ðнá¹ûÈçÏ£º µÃµ½µÄ½á ÔĶÁÈ«ÎÄ
posted @ 2021-01-04 13:36 ÏÄÈÕµÄÎ÷¹Ï¾ý ÔĶÁ(99) ÆÀÂÛ(0) ÍƼö(0) ±à¼