select a.* from (SELECT ID,REGION AS NAME,PROJECT_ID AS PROJECTID FROM TBL_WFTT_CFGREGION WHERE STATE=1 and connect_by_isleaf=1 start with parentid is null
connect by prior id= parentid ORDER BY NAME ASC) a where a.projectid='1025'
树节点执行的语句
start with …………
connect by prior