错误: ORA-12704: 字符集不匹配
select case when t.machinename='GD500-226'
then 'GD500' else t.machinename end from faultinfo t
正确:
select case when t.machinename='GD500-226'
then 'GD500' else cast(t.machinename as varchar2(50)) end from faultinfo t