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

DRG-11861: CSO-server Replies

1 Answers  


IMP-00050: Dump file and log file cannot be identical

1 Answers  


ORA-00300: illegal redo log block size string specified - exceeds limit of string

1 Answers  


PLS-00337: "string" matches too many object table aliases

1 Answers  


LPX-00310: element ~S not found in ~S

1 Answers  






PCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I

1 Answers  


ORA-39108: Worker process string violated startup protocol. Worker error:

1 Answers  


ORA-32621: illegal aggregation in UNTIL iteration condition

1 Answers  


TNS-12636: Packet send failed

1 Answers  


NZE-29249: an unrecognized state was passed to a cryptographic function

1 Answers  


ORA-25142: default storage clause specified twice

1 Answers  


ORA-12476: least upper bound resulted in an invalid OS label

1 Answers  


Categories