/** 首先,自我检讨一下,在没完全了解树结构查询语句就开始用,结果一直在其他地方找问题.../
树结构查询语句并不复杂:
select .. from.. where ...[conditon] start with ...[condition] connect by prior ...[condition]
例如 :
select dm, mc, pid from tree where ...[condition] start with dm = '根节点条件' connect by prior dm = pid