Question

mybatis 对oracle数据库进行操作时，对属性用 as 设置别名，但是报错

SQL: select id as 'u_id',name,password from (select rownum r,id,name,password from users) where r >= ? and r <= ?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字

Answer 1

select id as "u_id"

Answer 2

没空格啊，关键字都写到一块儿去了。