Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16532: Data Guard broker configuration does not exist.

1 Answers  


ORA-22166: collection is empty

1 Answers  


ORA-28109: the number of related policies has exceeded the limit of 16

1 Answers  


ORA-30927: Unable to complete execution due to failure in temporary table transformation

1 Answers  


ORA-17508: I/O request buffer ptr is not alligned

1 Answers  






ORA-16400: quota attributes are not allowed with DB_RECOVERY_FILE_DEST

1 Answers  


RMAN-06721: could not normalize path for file: "string"

1 Answers  


ORA-02144: no option specified for ALTER CLUSTER

1 Answers  


DRG-10518: an operation is in progress which conflicts with string request

1 Answers  


PLS-00635: method does not override

1 Answers  


ORA-00085: current call does not exist

1 Answers  


LFI-00128: Carriage Control is only valid for Standard file objects.

1 Answers  






Categories