ORCALE 树形递归查询树并且排序

      SELECT  id "id",pid "pId",mc "name",level "level"
        FROM ZYRZ_ZYZPBGFJZB_NTKO
        where nd='2010' and yxdm = '0001' and zydm = '0001' start with pid='0'  
        CONNECT BY PRIOR id = pid
      order siblings by sx asc;