+ -
当前位置:首页 → 问答吧 → SQL求教

SQL求教

时间:2011-12-18

来源:互联网

UPDATE B
  SET B.ID = A.ID,
  B.NAME = A.NAME,
  B.DRIVING= A.DRIVING,
  MODIFIED_TM = SYSDATE FROM DRIVER_A A, DRIVER_B B
  WHERE B.ID != A.ID
  AND B.NAME != A.NAME
  AND B.DRIVING!= A.DRIVING
  AND B.ID = 1  
执行时:PL/SQL报:ORA-00993:SQL命令末正确结束,请问是什么原因?要怎样改才正确?

作者: itcast123   发布时间: 2011-12-18

SQL code
update DRIVER_B 
set (name,DRIVING,MODIFIED_TM ) 
= (select name,DRIVING,sysdate from DRIVER_A where ID = 1 )
where DRIVER_B.id = 1  

作者: dawugui   发布时间: 2011-12-18

热门下载

更多