为什么这条查询在ORACLE下出错啊~

[saintqiqi]

SELECT CASE IsAuditing WHEN '0'THEN '未审核' WHEN '1'THEN '已审核'WHEN '2'THEN '拒绝 ' Else '错误' END AS IsAuditing, ( SELECT RealName FROM UserbaseInfo u WHERE u.UserID = em.UserID) AS RealName, ( SELECT Name FROM Equipments e WHERE em.EquipID = e.usefor+e.ID) AS EquipName,* from EquipMaintainApplication em;

在SQL SERVER 下调试可以~
在ORACLE下报错

ERROR 位于第 1 行:
ORA-00936: 缺少表达式

[saintqiqi]

up

[jimu8130]

sqlserver和oracle的语法是由区别的，你查下相关资料咯，看case语句能这样用在oracle里面
你应该在oracle板块问哑

[hchxxzx]

SELECT
decode(em.IsAuditing,
'0', '未审核' ,
'1', '已审核',
'2', '拒绝',
'错误'),
( SELECT RealName FROM UserbaseInfo u WHERE u.UserID = em.UserID) AS RealName,
( SELECT Name FROM Equipments e WHERE em.EquipID = e.usefor+e.ID) AS EquipName,
*
from EquipMaintainApplication em;

[saintqiqi]

不过我单独一段段调试，象：
SELECT CASE IsAuditing WHEN '0'THEN '未审核' WHEN '1'THEN '已审核'WHEN '2'THEN '拒绝 ' Else '错误' END AS IsAuditing from EquipMaintainApplication em;

可以通过～～

[ChengKing]

UP