PLS-00210: an OTHERS clause is required in this CASE statement

PLS-00210: an OTHERS clause is required in this CASE statement
Cause: Unless the clauses of a CASE statement mention all values of the type of the selecting expression, an OTHERS clause must be provided as the last clause of the CASE statement. It is impossible to cover all values of type INTEGER (or NUMBER), so an OTHERS clause is always required when the expression following the keyword CASE is of type INTEGER (or NUMBER).
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00210：此CASE语句中需要一个OTHERS子句,
.原因：除非CASE语句的子句提及选择表达式类型的所有值，否则必须提供OTHERS子句作为CASE语句的最后一个子句。不可能覆盖INTEGER（或NUMBER）类型的所有值，因此当关键字CASE之后的表达式的类型为INTEGER（或NUMBER）时，始终需要使用OTHERS子句。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

PLS-00210: an OTHERS clause is required in this CASE statement

1 个回答

相似问题