select zp.personID
from zzxk_person zp
start with zp.personID = 45
connect by prior personID = parentID
-----------
请问这写sql 什么意思呀
from zzxk_person zp
start with zp.personID = 45
connect by prior personID = parentID
-----------
请问这写sql 什么意思呀
调试欢乐多
要从开始personid=45中取
条件personid=parentid
connect by prior personID = parentID
这2句什么意思呀
connect by在Oracle中是可以查询出当前节点的所有子节点的,也就是说是获取树型的