aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00665: ORDER BY and CLUSTER BY clauses require a PARTITION BY clause

PLS-00665: ORDER BY and CLUSTER BY clauses require a PARTITION BY clause
Cause: An attempt was made to specify an ORDER BY or CLUSTER BY clause without also specifying a PARTITION BY clause.
Action: Add a PARTITION BY clause, or remove the ORDER BY or CLUSTER BY clause.

请先 登录 后评论

1 个回答

小智
PLS-00665:ORDER BY和CLUSTER BY子句需要一个PARTITION BY子句,
.原因:尝试指定ORDER BY或CLUSTER BY子句,而不指定PARTITION BY子句。,
.操作:添加PARTITION BY子句,或删除ORDER BY或CLUSTER BY子句。,
.
请先 登录 后评论