Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28535: invalid Heterogeneous Services context

1 Answers  


DRG-10205: server deregister failed

1 Answers  


PCC-02439: FOR clause not allowed in this COLLECTION statement

1 Answers  


QSM-00773: the parameter string contains the invalid string name string

1 Answers  


ORA-32056: invalid number of extents

1 Answers  






ORA-01719: outer join operator (+) not allowed in operand of OR or IN

2 Answers  


ORA-16640: CRS warns that multiple instances may still be running.

1 Answers  


ORA-13760: duplicate entry for "SQL_ID" "string" in "SQL Tuning Set" "string"

1 Answers  


ORA-28504: ROWID not found in ROWID cache for heterogeneous database link

1 Answers  


ORA-29265: HTTP header not found

1 Answers  


NNL-00003: memory exhausted

1 Answers  


SQL-02150: Encountered zero length in ANSI dynamic SET statement

1 Answers  






Categories