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-13335: LRS measure information not defined

1 Answers  


ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.

1 Answers  


ORA-00374: parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]

1 Answers  


DRG-10830: SHARELEVEL is not 0 or 1

1 Answers  


EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export

1 Answers  


ORA-06307: IPA: Cannot reset connection

1 Answers  


ORA-06538: statement violates string RESTRICT_REFERENCES pragma

1 Answers  


ORA-07402: sprst: cannot restore user signal handler.

1 Answers  


DRG-11115: a value for string must be specified

1 Answers  


ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.

1 Answers  


QSM-02088: mv omits at least one grouping key from the select list

1 Answers  


RMAN-06508: MAXSETSIZE string kbytes should be greater than blocksize string bytes

1 Answers  


Categories