SELECT FF.*, AF.FUNCGROUPNAME FROM
(SELECT F.FUNCCODE,F.FUNCNAME,F.ISMENU,F.FUNCGROUPID,
(CASE WHEN PARTY_ID IS NULL THEN 0 ELSE 1 END) ISCHECK FROM APP_FUNCTION F
LEFT JOIN CAP_RESAUTH CR ON F.FUNCCODE = CR.RES_ID AND CR.PARTY_ID = #role:int#) FF
LEFT JOIN APP_FUNCGROUP AF ON FF.FUNCGROUPID = AF.FUNCGROUPID
ORDER BY FUNCGROUPID
这是一条sqlserver的语句,转成oracle的语句应该怎么转?主要是CASE函数那~~~求帮忙