发布时间:2015-01-05 11:12:51
今天遇到一个update更新的错误,用到了几个知识点拿出来备份下 出错语句如下UPDATE request SET status='COMPLETE'WHERE REQUEST_ID IN(select REQUEST_ID from repair A ,request Bwhere (status='TERMINATE' or nvl(terminate_flag,0)=1)AND b.status='UNCOMPLETE'AND A.TICKET_ID=B.TICKET_ID)首先分析.........【阅读全文】