大神们,在线等啊,项目上需要连oracle数据库取数,下面这段脚本出现:自定义SQL语句执行异常:ORA-00972: 标识符过长 错误,不知道哪里出了问题,请各位大神指教,感激不尽
SELECT STORE_SHORTNAME
,DIM_SHOP_ID
,STORE_ID
,YYMM
,SUM(CASE WHEN MEA_ORD_ATTR = '正单' THEN 自主代步服务结算台次 ELSE 0 END)
+SUM(CASE WHEN MEA_ORD_ATTR = '蓝单' THEN 自主代步服务结算台次 ELSE 0 END)
-SUM(CASE WHEN MEA_ORD_ATTR = '红单' THEN 自主代步服务结算台次 ELSE 0 END) 自主代步服务结算台次
FROM(
SELECT COUNT(DISTINCT FAK_ORD_ORDERNO) 自主代步服务台次_售后
,DIM_SHOP_ID
,SUBSTR(FAT_ORD_ARCONFIRMDATE,1,7) YYMM
,ST.STORE_ID
,ST.STORE_SHORTNAME
,MEA_ORD_ATTR
FROM BI_FAC_BAS_DTL_ORD ORD
LEFT JOIN DT_DAILY_INFO@ERP ST ON ORD.DIM_SHOP_ID = ST.STORE_NO
WHERE FAT_ORD_ARCONFIRMDATE IS NOT NULL
AND MEA_ORD_ORDERTYPE = '延保销售'
AND MEA_ORD_GOODSMIDCLS = '鸿粤代步专享服务旧车'
AND MEA_ITEM_DEPTNAME IN('售后部','客服部')
AND MEA_ORD_PAYMODE = '客户付费'
GROUP BY DIM_SHOP_ID
,SUBSTR(FAT_ORD_ARCONFIRMDATE,1,7)
,ST.STORE_ID
,ST.STORE_SHORTNAME
,MEA_ORD_ATTR
)GROUP BY DIM_SHOP_ID
,YYMM
,STORE_ID
,STORE_SHORTNAME