解决方法:需要对数据类型进行转换。
Specifying the USING CHAR_CS argument converts text into the database character set. The output datatype is VARCHAR2.
Specifying the USING NCHAR_CS argument converts text into the national character set. The output datatype is NVARCHAR2.
(A表字段c_xxx:varchar,B表c_xxx:nvarchar)
select translate(c_xxx USING NCHAR_CS) from A
union all
select c_xxx from B
或者
select c_xxx from A
union all
select translate(c_xxx USING CHAR_CS) from B