SELECT * from 表名 t
where 查询条件
start with 关联主键 connect by t.父节点 =prior t.关联主键
ORDER BY 排序条件
例子
SELECT * from sys_dzk t
where t.DZKNAME LIKE '%1%'
start with t.DZKID=1 connect by t.PARENTID=prior t.DZKID
ORDER BY t.DZKID desc