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-24270: a row already exists in the string table for these parameters

1 Answers  


ORA-19771: cannot rename change tracking file while database is open

1 Answers  


DRG-52204: error while registering index

1 Answers  


ORA-13619: The procedure argument string is greater than the maximum allowable length of string characters.

1 Answers  


PLS-00900: can't find body of unit 'string'

1 Answers  


ORA-12700: invalid NLS parameter value (string)

1 Answers  


ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists

1 Answers  


ORA-12407: unauthorized operation for policy string

1 Answers  


AUD-00714: internal error

1 Answers  


ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string

1 Answers  


ORA-00040: active time limit exceeded - call aborted

1 Answers  


ORA-09312: slspool: error spooling file to printer

1 Answers  


Categories