ORA-12704: 字符集不匹配,union 后面加了“TO_CHAR()”或者 CAST('11111' AS nvarchar2(50)),基本就搞定了。
TO_CHAR(CAST('11111' AS nvarchar2(50))) AS "货品编号" ,
SELECT B.MANUFACTURENO ,
B.C_SHORT_DE ,
C.COLOR_NAME ,
D.SIZENAME ,
SUM(a.QTY_UNIT) AS QTY,
(
CASE
WHEN B.RETAILPRICE IS NULL
THEN NVL (B.RETAILPRICE, 0)
WHEN B.RETAILPRICE = 0
THEN NVL (B.RETAILPRICE, 0)
ELSE B.RETAILPRICE
END
) AS RETAILPRICE ,
SH.SHOP_CNAME ,
C.COLORSCHEME AS "配色",
A.ITEM_CODE AS "货品编号",
TRIM (A.ITEM_CODE) || TRIM (A.COLOR_CODE) ||TRIM (D.SIZECODE) AS SKU,
SH.SHOP_CODE,
PP.PROV_CNAME,
CI.CITY_CNAME,
SH.ADDRESS,
B.itembasis
FROM AAAA.LOT A
UNION
SELECT CAST('test' AS nvarchar2(50)) AS MANUFACTURENO ,CAST('test' AS nvarchar2(50)) AS C_SHORT_DE ,
CAST('test' AS nvarchar2(50)) AS COLOR_NAME ,
CAST('test' AS nvarchar2(50)) AS SIZENAME,
1 AS QTY ,
1 RETAILPRICE ,
CAST('北京店' AS nvarchar2(50)) AS SHOP_CNAME,
CAST('11111' AS nvarchar2(50)) AS "配色",
TO_CHAR(CAST('11111' AS nvarchar2(50))) AS "货品编号" ,
TO_CHAR(CAST('11111111111111' AS nvarchar2(50))) AS SKU ,
TO_CHAR(CAST('BJ002' AS nvarchar2(50))) AS SHOP_CODE ,
CAST('北京市' AS nvarchar2(50)) AS PROV_CNAME ,
CAST('北京' AS nvarchar2(50)) AS CITY_CNAME ,
CAST('北京市add' AS nvarchar2(50)) AS ADDRESS,
CAST('100%羊绒' AS nvarchar2(50)) AS itembasis