千尺梦
2017-11-17 01:57mybatis+oracle 一条update方法一直报sql命令为结束错误,不知道怎么回事
<update id="assignPlural" >
update exam_task set teacherId=#{teacherId} where id in (
select id from (
select id , row_number() over (partition by answerId order by null) m from
( select id , answerId from exam_task where answerId in
(select id from exam_answer where questionId =#{questionId})
and
answerId not in
(select answerId from exam_task where teacherId=#{teacherId})
)
) where m=1
) where rownum <=#{assignNum}
</update>
- 点赞
- 回答
- 收藏
- 复制链接分享
2条回答
为你推荐
- 请教一下,到底我的mapper.xml哪里出错了,弄不明白为什么找不到我写的log类
- java
- spring
- xml
- tomcat
- eclipse
- 1个回答
- 急 Oracle ORA-00904 标识符无效问题
- 数据库
- oracle
- 0个回答
- java.sql.SQLException: ORA-01002: 读取违反顺序 大家帮我看看
- dao
- 0个回答
- Mybatis更新字段不生效
- mybatis
- intellij-idea
- 不生效
- 更新
- 6个回答
- mybatis+oracle 一条update方法一直报sql命令为结束错误,不知道怎么回事
- mybatis
- 2个回答
换一换