PLS-00116: Duplicate where-clause in table expression
- 1 Answers
- 3671 Views
- I also Faced
- E-Mail Answers
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 |
ORA-02707: osnacx: cannot allocate context area
ORA-15107: missing or invalid ASM disk name
LSX-00148: annotation must come first in "~S"
ORA-30020: UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
DRG-51804: failed to write to file: %(1)
SQL*Loader-00811: error dropping external table: string
ORA-12657: No algorithms installed
ORA-09753: spwat: invalid process number.
NZE-28814: Cannot convert a number in Oracle format to native format.
ORA-01931: cannot grant string to a role
PCB-00581: "string" used as both host variable and indicator
LFI-00002: Out of memory. string
Oracle Errors 
