这个查询可以正常运行
select * from u_agent agent
inner join t_company_organ organ on agent.organ_id = organ.organ_id
inner join u_dict dict on dict.categoryid=5 and organ.area_code=dict.comments
where agent.isExcellence =1
and trunc(dict.keyid /100)*100 = 3700
这个update会报错:“ORA-00933: SQL command not properly ended”
update u_agent agent
set agent.account_status=1
from agent ------------去掉这个from 也是报一样的错
inner join t_company_organ organ on agent.organ_id = organ.organ_id
inner join u_dict dict on dict.categoryid=5 and organ.area_code=dict.comments
where agent.isExcellence =1
and trunc(dict.keyid /100)*100 = 3700这样会报错:“ORA-00971: missing SET keyword”
update u_agent agent
inner join t_company_organ organ on agent.organ_id = organ.organ_id
inner join u_dict dict on dict.categoryid=5 and organ.area_code=dict.comments
set agent.account_status=1 ---------把set放到了下面
where agent.isExcellence =1
and trunc(dict.keyid /100)*100 = 3700
select * from u_agent agent
inner join t_company_organ organ on agent.organ_id = organ.organ_id
inner join u_dict dict on dict.categoryid=5 and organ.area_code=dict.comments
where agent.isExcellence =1
and trunc(dict.keyid /100)*100 = 3700
这个update会报错:“ORA-00933: SQL command not properly ended”
update u_agent agent
set agent.account_status=1
from agent ------------去掉这个from 也是报一样的错
inner join t_company_organ organ on agent.organ_id = organ.organ_id
inner join u_dict dict on dict.categoryid=5 and organ.area_code=dict.comments
where agent.isExcellence =1
and trunc(dict.keyid /100)*100 = 3700这样会报错:“ORA-00971: missing SET keyword”
update u_agent agent
inner join t_company_organ organ on agent.organ_id = organ.organ_id
inner join u_dict dict on dict.categoryid=5 and organ.area_code=dict.comments
set agent.account_status=1 ---------把set放到了下面
where agent.isExcellence =1
and trunc(dict.keyid /100)*100 = 3700
解决方案 »
- 数据库domain constraint assertion的区别
- 分布式数据库的一点疑惑
- sql 语句的求助。
- oracle不能正常使用
- oracle 将查询的两行结果拼接
- 问一个变量定义的问题.
- oracle 入门问题,请各同行提建议.
- (讨论)基于SQL Server的程序代码移植到Oracle数据库中需要注意那些问题?
- 实例不能起来,报ORA-03113: end-of-file on communication channel,请问知道是什么原因吗
- oracle触发器,一张表在录入时,一个字段的值如何直接取另一个表字段的值
- oracle 用户权限设置完 但说不能检索表
- 国内著名电子商务网站诚聘DBA,大家速度报名啦
是我的inner join有问题 还是根本不能 inner join。
update 表名
set 字段=
where 条件我帮你改一下吧
UPDATE u_agent AGENT
SET AGENT.account_status = 1
WHERE AGENT.isexcellence = 1
AND TRUNC (dict.keyid / 100) * 100 = 3700
AND EXISTS (
SELECT 1
FROM t_company_organ organ, u_dict dict
WHERE AGENT.organ_id = organ.organ_id
AND dict.categoryid = 5
AND organ.area_code = dict.comments)
ORA-00904: "DICT"."DEYID": invalid identifier是因为别名在下面的那个查询里吧? 上面用不到? 如果用到了 就又等于用到两个表了bo?
这个错 刚才又写错了
UPDATE u_agent AGENT
SET AGENT.account_status = 1
WHERE AGENT.isexcellence = 1
AND EXISTS (
SELECT 1
FROM t_company_organ organ, u_dict dict
WHERE AGENT.organ_id = organ.organ_id
AND dict.categoryid = 5
AND organ.area_code = dict.comments
AND TRUNC (dict.keyid / 100) * 100 = 3700)