文档解释
ORA-41692: unsupported aggregate operator in the having/compute clause: string
Cause: An attempt was made to use an unsupported aggregate operator in the having or the compute clause in the rule condition.
Action: Correct the input and try again.
ORA-41692: unsupported aggregate operator in the having/compute clause: string是指在SQL语句的having或compute子句中，出现了不被支持的聚合运算符（string）。
官方解释
常见案例
SELECT * FROM test_table
WHERE price > 50
HAVING SUM(price) > 100 AND COUNT(*) > 5
一般处理方法及步骤
1、修复SQL语句，把having或compute子句计划用聚合函数或行数函数来替换，比如可以把上面的SQL语句修复为：
SELECT * FROM test_table
WHERE price > 50
GROUP BY price
HAVING SUM(price) > 100
2、尽可能减少执行逻辑，减少运算时间。
香港美国云服务器首选树叶云，2H2G首月10元开通。
树叶云（shuyeidc.com）提供简单好用，价格厚道的香港/美国云服务器和独立服务器。IDC+ISP+ICP资质。ARIN和APNIC会员。成熟技术团队15年行业经验。
文章来源网络，作者：运维，如若转载，请注明出处：https://shuyeidc.com/wp/253677.html<
