INSERT INTO T_USER(AD_ID,AD_ANUMBER,AD_14) VALUES(1,'123456','00') ON DUPLICATE KEY UPDATE AD_14='00';
在Oracle中执行弹出错误:ORA-00933:SQL命令未正确结束,求大家指点下,谢谢啦~~~
INSERT INTO T_USER(AD_ID,AD_ANUMBER,AD_14) VALUES(1,'123456','00') ON DUPLICATE KEY UPDATE AD_14='00';
在Oracle中执行弹出错误:ORA-00933:SQL命令未正确结束,求大家指点下,谢谢啦~~~
mysql 用 ON DUPLICATE KEY
oracle 用merge