PLS-00117: Duplicate connect-by clause in table expression
- 1 Answers
- 3406 Views
- I also Faced
- E-Mail Answers
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 |
QSM-02091: mv references a non-repeatable or session-sensitive expression
ORA-10582: The control file is not a backup control file
RMAN-06153: validation failed for datafile copy
ORA-30366: child JOIN KEY columns not in same relation as child level
DRG-51403: New index name not provided by kernel
ORA-12024: materialized view log on "string"."string" does not have primary key columns
ORA-28170: unsupported certificate version
ORA-00227: corrupt block detected in controlfile: (block string, # blocks string)
ORA-09807: Conversion of label from string to binary failed.
ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.
LPX-00312: cannot construct XML PI with content: ~S
ORA-13481: the destination type is not supported
Oracle Errors 
