PLS-00116: Duplicate where-clause in table expression

PLS-00116: Duplicate where-clause in table expression
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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00116：表中表达式中的重复的where子句,
.原因：在DELETE，SELECT或UPDATE语句中找到两个或多个WHERE子句。WHERE子句指定处理表中的行的条件。条件可以包含由AND或OR连接的多个逻辑表达式，但一个语句只能包含一个WHERE子句。,
.操作：删除其中一个WHERE子句，如有必要，可以使用AND或OR连接逻辑表达式,
.

aiaiDBA

13718043309

010-86462881

PLS-00116: Duplicate where-clause in table expression

1 个回答

相似问题