ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here
Cause: SYS_CONNECT_BY_PATH function was called at places other than the SELECT list and ORDER BY clause.
Action: Remove calls to SYS_CONNECT_BY_PATH function at places other than the SELECT list and ORDER BY clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

此处不允许使用ORA-30002：SYS_CONNECT_BY_PATH函数,
.原因：在除SELECT列表和ORDER BY子句以外的位置调用了SYS_CONNECT_BY_PATH函数。,
.操作：在除SELECT列表和ORDER BY子句以外的位置删除对SYS_CONNECT_BY_PATH函数的调用。,
.

aiaiDBA

13718043309

010-86462881

ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

1 个回答

相似问题