此SQL在missing上运行良好,但会产生一个错误"ORA-00907:缺少右括号“。SQL:SET VISIBLE = 0IN SELECT DELIVERY.ID FROM delivery WHEREDELIVERY.VISIBLE = 1 SELECT DELIVERY.ID FROM delivery LEFT JOIN inventory O
UPDATE FRA_SAPFROM FRA_SAP FES ON FES.ID = FE.IDjava.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properlyended
at oracle.jdbc.driver.T4CTTIoer.processE
我在ORACLE(10g) DB中使用以下查询。SELECT *来自student_table,其中student_no与‘%学生%’相交SELECT *来自student_table where student_no in (‘STUDENT 1234’,'STUDENT5678')知道如何解决这个错误吗