ORA-30365: left relation in the JOIN KEY clause cannot be
same as right



ORA-30365: left relation in the JOIN KEY clause cannot be same as right..

Answer / guest

Cause: The relation of the child columns on the left side of
the JOIN KEY clause was the same as that of the parent level
on the right side.

Action: Remove the JOIN KEY clause. It is not required or
allowed when the child and the parent are in the same relation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02008: non-join filter condition in WHERE or HAVING clause

1 Answers  


ORA-37005: (AWLISTALL03) number readers

1 Answers  


ORA-12838: cannot read/modify an object after modifying it in parallel

1 Answers  


ORA-31057: Display Name of the element being inserted is null

1 Answers  


NNC-00429: invalid octet string literal "string"

1 Answers  






ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name

1 Answers  


PLS-00500: invalid operator binding

1 Answers  


ORA-26060: Can not convert type identifier for column string

1 Answers  


PLS-00119: Duplicate having-clause in table expression

1 Answers  


ORA-01550: cannot drop system tablespace

1 Answers  


ORA-06780: TLI Driver: recv error code failed

1 Answers  


DRG-51028: unexpected error in fuzzy match expansion: %(1)

1 Answers  


Categories