阅读背景:

SQL语句结尾处多加了一个分号,导致出现 ------ORA-00911: 无效字符---错误

来源:互联网 


String sql = "select * from (select USER_ID,USER_NAME,FACEADDRESS,rownum as no FROM ((SELECT STUDENT_ID USER_ID,STUDENT_NAME USER_NAME,FACEADDRESS FROM XTGL_STUDENT WHERE student_name LIKE ? OR STUDENT_ID LIKE ? ) UNION(SELECT TEACHER_ID USER_ID,TEACHER_NAME USER_NAME,FACEADDRESS from XTGL_TEACHER WHERE TEACHER_NAME LIKE ? OR TEACHER_NAME LIKE ? )) )x WHERE (x.no <= "String sql = "select * from (select USER_ID,




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: