摘要： with subqry(id,name,pid) as( select PermissionInfoId id,pmscName name,parentPmsid pid from PermissionInfo where PermissionInfoId=23 union all select PermissionInfoId id,PmsCName name,ParentPmsId pid from PermissionInfo ,subqry where PermissionInfo.ParentPmsId=subqry.id) select * from subqry;---Oracl 阅读全文