sqlserver的sql语句转成oracle

Question

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函数那~~~求帮忙

Answer 1

表面看不用转就直接用，先拿到oracle执行下有无语法错误