select u.id,
u.username,
u.password,
u.work_mode,
u.ip_address,
u.stop_date,
u.calling_station_id,
u.is_binding,
u.is_enable,
u.account,
u.company,
u.department,
u.orderno,
u.accountnonexpired,
u.accountnonlocked,
u.credentialsnonexpired,
u.enabled,
u.name,
u.gender,
u.birthday,
u.cardid,
u.mobile,
u.tel,
u.email,
u.description,
u.NOT_FIRST_FLAG,
o.name as org_name,
o.id as org_id,
ur.role_names
from sys_psn_user u,
sys_psn_user_org uo,
sys_psn_org o,
(select u.id, listagg(r.name, ',') within group(order by r.name) as role_names
from sys_psn_user u, sys_psn_user_role ur, sys_psn_role r
where u.id = ur.user_id
and ur.role_id = r.id
group by u.id) ur
where u.id = uo.user_id(+)
and uo.org_id = o.id(+)
and u.id = ur.id(+)
and u.username=#{username}
最后执行结果是;[Err] ORA-00923: 未找到要求的 FROM 关键字;
哪里出问题了?
6 个解决方案
#1
SqlSession operation; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字