Oracle向下递归查询

                                                        String sqllsq="select t.resourcetypecode "
+" from CODE_RES_MATERIALTYPE t "
+" start with t.resourcetypecode='"+rt.getResourcetypecode()+"' "
+" connect by prior t.resourcetypecode = t.parentcode ";