MyBatis querying for Oracle ' Invalid column index ' and ORA-00911 ' invalid character ' error

1. Caused by:java.sql.SQLException: Invalid column index

Reference: http://bbs.csdn.net/topics/300179772

The configured SQL statement was incorrectly written

 select  distinct   '  

After using #{**}, no more single quotes are added. Corrected to

Select       distinct #{pkgname}  as Pkgname,                #{appname}  as AppName,                 as Versionname  from  where appkey=orderbydesc

2. ORA-00911 ' Invalid characters ' error

Reference Document: Http://www.cnblogs.com/zhangronghua/archive/2007/08/29/874484.html

The Oracle-configured statement does not have a semicolon, which does not appear to be a problem in MySQL and does not work in Oracle's statements.

MyBatis querying for Oracle ' Invalid column index ' and ORA-00911 ' invalid character ' error