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-02766: Invalid maximum of request descriptors

1 Answers  


PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


ORA-23406: insufficient privileges on user "string"

1 Answers  


ORA-02093: TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)

1 Answers  


ORA-29527: created Java source string"string"

1 Answers  


ORA-13418: null or invalid parameter(s) for set functions

1 Answers  


ORA-12647: Authentication required

1 Answers  


ORA-28658: This operation is supported only for Index-Organized tables

1 Answers  


NNO-00630: setting request-processing delay to number seconds

1 Answers  


PCC-01005: PROCEDURE DIVISION not found

1 Answers  


ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

1 Answers  


QSM-00801: the specified username string is invalid

1 Answers  


Categories