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命令末正确结束,请问是什么原因?要怎样改才正确?
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命令末正确结束,请问是什么原因?要怎样改才正确?
set (name,DRIVING,MODIFIED_TM )
= (select name,DRIVING,sysdate from DRIVER_A where ID = 1 )
where DRIVER_B.id = 1
set (name,DRIVING,MODIFIED_TM )
= (select name,DRIVING,sysdate from DRIVER_A where ID = 1 )
where DRIVER_B.id = 1
set (name,DRIVING,MODIFIED_TM )
= (select name,DRIVING,sysdate from DRIVER_A where ID = 1 )
where DRIVER_B.id = 1