求助,一直提示無效字符
求助:
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
求助:
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
2019-05-12
舉報
2019-05-28
as后面的部門加上單引號試試