一个sql语句,请帮看看
时间:2011-09-03
来源:互联网
select t4.orgid,t4.orgname,t2.paper_name,t1.object_id,t.name, klrms_get_dictname_by_dictid(t.type) type,t.method_summary,decode(t1.hege_flag,1,'合格',0,'不合格') qualified
from t_klrms_auditpoint t,
t_kams_applay_auditpoint t1,
t_kams_work_paper t2,t_kams_project_applay t3,t_krms_org t4
where t.object_id=t1.auditpoint_id
and t1.applay_id in (select p.object_id from t_kams_project_applay p where p.project_main_id=4522)
and t2.object_id=t1.template_id
and t3.auditer=t4.orgid
and t1.applay_id=t3.object_id;
这条语句,我在pl/sql执行的时候报“无效数字”的错误,这一句“select p.object_id from t_kams_project_applay p where p.project_main_id=4522”查出来,应该是4523,4524,我如果直接把in后面的括号里换成4523,4524就正确,这是怎么回事呢
from t_klrms_auditpoint t,
t_kams_applay_auditpoint t1,
t_kams_work_paper t2,t_kams_project_applay t3,t_krms_org t4
where t.object_id=t1.auditpoint_id
and t1.applay_id in (select p.object_id from t_kams_project_applay p where p.project_main_id=4522)
and t2.object_id=t1.template_id
and t3.auditer=t4.orgid
and t1.applay_id=t3.object_id;
这条语句,我在pl/sql执行的时候报“无效数字”的错误,这一句“select p.object_id from t_kams_project_applay p where p.project_main_id=4522”查出来,应该是4523,4524,我如果直接把in后面的括号里换成4523,4524就正确,这是怎么回事呢
作者: lc999 发布时间: 2011-09-03
p.project_main_id 是什么数据类型
是字符串的话
改为右边加''
p.project_main_id='4522'
是字符串的话
改为右边加''
p.project_main_id='4522'
作者: canhui87 发布时间: 2011-09-03
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28