如果表中存在层次数据，则可以使用层次化查询子句查询出表中行记录之间的层次关系基本语法：[ START WITH CONDITION1 ] CONNECT BY [ NOCYCLE ] CONDITION2示例：select id,parentid,partname, level from tabpart start with id = 11 connect by nocycle prior id = parentid;[...]