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-25154: column part of USING clause cannot have qualifier

1 Answers  


ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-06605: LU6.2 Driver: Unexpected line turnaround

1 Answers  


ORA-15090: handle string is not a valid descriptor

1 Answers  


ORA-31463: logfile location string is an empty directory

1 Answers  


ORA-23443: missing template parameter

1 Answers  


ORA-30748: column string already enabled to store objects of type string.string

1 Answers  


TNS-00283: Listening on the following TNS addresses:

1 Answers  


RMAN-06727: could not locate datafilecopy string

1 Answers  


ORA-29811: missing STATISTICS keyword

1 Answers  


NNL-00207: Scheduled reload check to occur in string

1 Answers  


ORA-38736: Wrong thread number string in flashback log file header.

1 Answers  


Categories