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

AMD-00103: %s "string" does not have a string

1 Answers  


ORA-14084: you may specify TABLESPACE DEFAULT only for a LOCAL index

1 Answers  


O2F-00304: Invalid filename for the INTYPE file

1 Answers  


DRG-12009: A new set of rules is requested to be added to your setup - continue?

1 Answers  


ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

1 Answers  






ORA-06432: ssaio: Buffer Not Aligned

1 Answers  


ORA-01089: immediate shutdown in progress - no operations are permitted

1 Answers  


NNL-00412: Number of requests: number

1 Answers  


ORA-12726: unmatched bracket in regular expression

1 Answers  


ORA-28534: Heterogeneous Services preprocessing error

1 Answers  


ORA-12034: materialized view log on "string"."string" younger than last refresh

2 Answers  


ORA-00228: length of alternate controlfile name exceeds maximum of string

1 Answers  


Categories