求助:
SQL> select username,case username when 'aaa' then '计算机部门' when 'bbb' then '市场部门' else '其他部门'
2 end as 部门 from users;
end as 部门 from users
*
ERROR at line 2:
ORA-00911: invalid character
as后面的部门加上单引号试试