ORA-00905:缺少关键字错误
ORA-00905:缺少关键字错误
提问于 2014-04-15 08:28:58
每当我尝试以下代码时，我都会得到这个令人讨厌的错误：
select
gam.acid,
gam.foracid,
gam.acct_name,
gam.sol_id,
sol.sol_desc,
gam.gl_sub_head_code,
case gsh.gl_code
when cast(gl_code as int) >= 01 and cast(gl_code as int) <=13
or cast(gl_code as int) >= 15 and cast(gl_code as int) <=24 then 'A'
when cast(gl_code as int) >= 28 and cast(gl_code as int) <= 31
or cast(gl_code as int) >= 33 and cast(gl_code as int) <= 39
or cast(gl_code as int) = 41
or cast(gl_code as int) >= 43 and cast(gl_code as int) <= 48 then 'L'
when cast(gl_code as int) = 51
or cast(gl_code as int) = 53
or cast(gl_code as int) >= 55 and cast(gl_code as int) <= 57 then 'C'
when cast(gl_code as int) >= 61 and cast(gl_code as int) <= 70
or cast(gl_code as int) >= 72 and cast(gl_code as int) <= 81 then 'I'
when cast(gl_code as int) = 84 or cast(gl_code as int) = 85
or cast(gl_code as int) >= 87 and cast(gl_code as int) <= 94 then 'E'
when cast(gl_code as int) >= 97 and cast(gl_code as int) <= 99 then 'S'
else null
end as gl_classification
from tbaadm.gam我觉得有些东西在代码中不合适，或者我忘了做/添加一些事情。任何帮助都将不胜感激。
回答 2
Stack Overflow用户
回答已采纳
发布于 2014-04-15 08:33:57
construct有两个替代语法：
CASE foo WHEN 1 THEN 'blah' END
CASE WHEN foo=1 THEN 'blah' END你试图同时使用这两种方法：
case gsh.gl_code
when cast(gl_code as int) >= 01它应该是：
select case
--gsh.gl_code remove this
when cast(gl_code as int) >= 01 and cast(gl_code as int) <=13
or cast(gl_code as int) >= 15 and cast(gl_code as int) <=24 then 'A'
when cast(gl_code as int) >= 28 and cast(gl_code as int) <= 31
or cast(gl_code as int) >= 33 and cast(gl_code as int) <= 39
or cast(gl_code as int) = 41
or cast(gl_code as int) >= 43 and cast(gl_code as int) <= 48 then 'L'
when cast(gl_code as int) = 51
or cast(gl_code as int) = 53
or cast(gl_code as int) >= 55 and cast(gl_code as int) <= 57 then 'C'
when cast(gl_code as int) >= 61 and cast(gl_code as int) <= 70
or cast(gl_code as int) >= 72 and cast(gl_code as int) <= 81 then 'I'
when cast(gl_code as int) = 84 or cast(gl_code as int) = 85
or cast(gl_code as int) >= 87 and cast(gl_code as int) <= 94 then 'E'
when cast(gl_code as int) >= 97 and cast(gl_code as int) <= 99 then 'S'
else null
end as gl_classification
from tbaadm.gamStack Overflow用户
发布于 2014-04-15 08:37:44
您可以尝试使用括号对AND/OR条件赋予优先级。例如：
when (cast(gl_code as int) >= 01 and cast(gl_code as int) <=13)
or (cast(gl_code as int) >= 15 and cast(gl_code as int) <=24) then 'A'也许会有帮助..。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/23078331
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号