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-06530: Reference to uninitialized composite

1 Answers  


ORA-06803: TLI Driver: the IPX device file could not be opened

1 Answers  


ORA-06028: NETASY: unable to intialise for logging

1 Answers  


NNL-00013: not performed, permission denied for supplied password

1 Answers  


PLS-00324: cursor attribute may not be applied to non-cursor 'string'

1 Answers  






ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV

1 Answers  


NZE-28815: Cannot convert a number in native format to Oracle format.

1 Answers  


ORA-08498: Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'

1 Answers  


ORA-19683: real and backup blocksize of file string are unequal

1 Answers  


RMAN-06488: restore from autobackup does not allow any other modifiers

1 Answers  


ORA-00071: process number must be between 1 and string

1 Answers  


ORA-29533: attempt to overwrite class or resource string while defining or compiling string.string

1 Answers  


Categories