文档解释 ORA-41692: unsupported aggregate operator in the having/compute clause: string Cause: An attempt was made to u
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、尽可能减少执行逻辑，减少运算时间。
--结束END--
本文标题: ORA-41692: unsupported aggregate operator in the having/compute clause: string ORACLE 报错 故障修复 远
本文链接: https://lsjlt.com/news/532049.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
官方手机版
微信公众号
商务合作
0