镜花水月之西施泪在线:CONNECT BY PRIOR 的问题

来源：百度文库编辑：杭州交通信息网时间：2024/05/04 19:04:41

①．
===========================================================
START WITH ZY22》FATHER ＝画面》FATHER
ZY22》CDJ＝画面》CDJ
ZY22》day_start≤NVL(画面》day,'99999999')
ZY22》day_end≥NVL(画面》day,'00000000')
CONNECT BY PRIOR ZY22》SON＝ZY22》FATHER
PRIOR ZY22》CDJ＝ZY22》CDJ
ZY22》day_start≤NVL(画面》day,'99999999')
ZY22》day_end≥NVL(画面》day,'00000000')
===========================================================
请帮忙分析一下这段SQL文。。谢谢。。
自己做了几个实验，还是不能透彻的搞懂。。。。

②．关于“CONNECT BY PRIOR ZY22》SON＝ZY22》FATHER”这句，
要是写为“CONNECT BY PRIOR ZY22》FATHER＝ZY22》SON”，
结果会不一样吗？做实验时好像结果是一样的。。
我就郁闷了，我觉得父子关系写反的话，出来结果的顺序也
应该是反的才对。。。

请高手知道！
谢谢！
参考文:
http://zhidao.baidu.com/question/2045639.html

CONNECT BY PRIOR 的问题 hibernate中怎么实现connect by的查询 connect...to与connect...with的区别科隆2的问题~Failed to connect World Server! bt的问题求教cann't connect tracker [asp]order by的问题 with ， by 的用法问题 a sample used for the final approval by buyer prior to mass prodrction sent by seller to buyer prior to every shipment,not just for every contract shall not beassigned by either party without the prior written consent of the other party