Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations

1 Answers  


NNL-00402: Authoritative server: string

1 Answers  


ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 Answers  


DRG-10819: could not open contains cursor

1 Answers  


ORA-24431: Statement does not exist in the cache

1 Answers  


O2U-00208: One or more characters in an attribute name were not legal identifier characters

1 Answers  


ORA-32821: subscriber queue and exception queue must have same payload type

1 Answers  


ORA-27490: cannot open disabled window "string.string"

1 Answers  


ORA-01239: database must be in ARCHIVELOG mode to use external cache

1 Answers  


ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 Answers  


PLS-01503: The expression in a SET clause must not include a set function

1 Answers  


ORA-32584: missing LOG keyword

1 Answers  


Categories