PLS-00117: Duplicate connect-by clause in table expression
- 1 Answers
- 2831 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 |
ORA-13025: polygon does not close
RMAN-04032: using contents of file string
ORA-14621: cannot add subpartition when DEFAULT subpartition exists
ORA-12699: Native service internal error
ORA-19555: invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
ORA-32304: materialized views with user-defined types cannot use prebuilt table
PLS-00726: MODIFY ELEMENT is supported only on schema-level varray and nested tables
ORA-00050: operating system error occurred while obtaining an enqueue
QSM-01126: query rewritten with set operator materialized view, string
ORA-02309: atomic NULL violation
ORA-13007: an invalid HEX character was detected
ORA-19763: compatibility version string is higher than maximum allowed: string
Oracle Errors 
