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-39132: object type "string"."string" already exists with different hashcode

1 Answers  


QSM-02036: in-list present in mv

1 Answers  


QSM-01127: query rewritten with multiple MVs

1 Answers  


ORA-10587: Invalid count for ALLOW n CORRUPTION option

1 Answers  


TNS-01201: Listener cannot find executable string for SID string

1 Answers  


ORA-13010: an invalid number of arguments has been specified

1 Answers  


RMAN-20009: database incarnation already registered

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


RMAN-06514: archived logs required to recover from this copy will not be kept

1 Answers  


ORA-03243: destination dba overlaps with existing control information

1 Answers  


RMAN-10026: network error number-number occurred registering connection

1 Answers  


LSX-00256: empty character class expression

1 Answers  


Categories