跪求各位大牛指引，一直报：ORA-00907: 缺失右括号

Question

使用mybatis框架，sql语句为：

SELECT () FROM BLQL_USER

1=1

and USERNAME LIKE '%${username}%'

and JOBNUMBER LIKE '%${jobnumber}%'

and ENABLE LIKE '%${enable}%'

and PHONE LIKE '%${phone}%'

ORDER BY CREATETIME

检查修改了好几次后台还是一直报：
The error occurred while setting parameters
SQL: SELECT ( ID,USERNAME,PASSWORD,REALNAME,JOBNUMBER,DESCRIPTION,CREATETIME,PHONE,EMAIL,ENABLE ) FROM BLQL_USER WHERE 1=1
Cause: java.sql.SQLSyntaxErrorException: ORA-00907: 缺失右括号

跪求各位技术大牛指引，小弟不胜感激。

Answer 1

sql语句的正确格式是：

select 列名1，列名2，... from 表 where 条件 order by 列 desc|asc

SELECT 后面的括号不需要