寻子:
SELECT * FROM shop_syscategory s
CONNECT BY PRIOR id= parentid
START WITH s.id = 11
寻父:
SELECT * FROM shop_syscategory s
CONNECT BY id= PRIOR parentid
START WITH s.id = 50009041
主要是 prior 位置的区别
关于oracle的树型结构查询详见附件(来自于互联网)