PLS-00116: Duplicate where-clause in table expression



PLS-00116: Duplicate where-clause in table expression..

Answer / guest

Cause: Two or more WHERE clauses were found in a DELETE,
SELECT, or UPDATE statement. The WHERE clause specifies a
condition under which rows in a table are processed. The
condition can contain several logical expressions connected
by AND or OR, but a statement can contain only one WHERE clause.

Action: Remove one of the WHERE clauses and, if necessary,
connect logical expressions by AND or OR

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06701: could not construct path for file: "string"

1 Answers  


NNL-00975: Desired data type: string

1 Answers  


NNL-00970: System query index number: number

1 Answers  


ORA-31056: The document being inserted does not conform to string

1 Answers  


RMAN-08526: channel string: string

1 Answers  






ORA-06744: TLI Driver: listener cannot bind

1 Answers  


ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

1 Answers  


ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)

1 Answers  


ORA-16228: Insufficient recovery for logical standby

1 Answers  


NZE-28793: variable bind failure

1 Answers  


PLW-05003: same actual parameter(string and string) at IN and NOCOPY may have side effects

1 Answers  


ORA-02775: Invalid request done signal

1 Answers  


Categories