oracle bad sql grammer 今天遇到这样的提示信息,把sql在plsql中进行执行,一切OK,就是在调试java代码的时候,报错误的sql 语法问题,经过仔细检查发现,在java代码中有一个“;”导致的,郁闷,希望遇到的朋友给以帮助,节省时间
sql.append("update sr.card_info sci set sci.discount = '0.91' WHERE sci.card_id in ( '231','572','666','10264','10265','17660','7319','10320','10321','17711' ) [color=red]; [/color] ");
sql.append("update sr.card_info sci set sci.discount = '0.91' WHERE sci.card_id in ( '231','572','666','10264','10265','17660','7319','10320','10321','17711' ) [color=red]; [/color] ");