PLS-00117: Duplicate connect-by clause in table expression

PLS-00117: Duplicate connect-by clause in table expression
Cause: Two or more CONNECT BY clauses were found in a SELECT statement. The CONNECT BY clause defines a relationship used to return rows in a hierarchical order. The relationship can contain two expressions separated by a relational operator (such as = or !=), but a statement can contain only one CONNECT BY clause.
Action: Remove one of the CONNECT BY clauses and, if necessary, separate expressions by a relational operator.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00117：表表达式中的Duplicate connect-by子句,
.原因：在SELECT语句中找到两个或多个CONNECT BY子句。CONNECT BY子句定义用于以层次顺序返回行的关系。该关系可以包含由关系运算符分隔的两个表达式（如=或！=），但一个语句只能包含一个CONNECT BY子句。,
.操作：删除一个CONNECT BY子句，如有必要，由关系运算符分隔表达式。,
.

aiaiDBA

13718043309

010-86462881

PLS-00117: Duplicate connect-by clause in table expression

1 个回答

相似问题