ORA-00976: Specified pseudocolumn or operator not allowed here.

ORA-00976: Specified pseudocolumn or operator not allowed here.
Cause: LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or CONNECT_BY_ISCYCLE was specified at an illegal location.
Action: Remove LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or CONNECT_BY_ISCYCLE.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00976：在此不允许指定伪列或运算符。,
.原因：在非法位置指定了LEVEL，PRIOR，ROWNUM，CONNECT_BY_ROOT，CONNECT_BY_ISLEAF或CONNECT_BY_ISCYCLE。,
.操作：删除LEVEL，PRIOR，ROWNUM，CONNECT_BY_ROOT，CONNECT_BY_ISLEAF或CONNECT_BY_ISCYCLE。,
.

aiaiDBA

13718043309

010-86462881

ORA-00976: Specified pseudocolumn or operator not allowed here.

1 个回答

相似问题