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

RMAN-06727: could not locate datafilecopy string

1 Answers  


DRG-12406: invalid CTX EXEC tag attribute (string)

1 Answers  


RMAN-06735: Do you really want to drop the database (enter YES or NO)?

1 Answers  


ORA-30509: client logoff triggers cannot have AFTER type

1 Answers  


ORA-12513: TNS:service handler found but it has registered for a different protocol

1 Answers  


TNS-01160: Trace level was not specified

1 Answers  


ORA-27071: unable to seek to desired position in file

1 Answers  


PCC-00007: Invalid WHENEVER condition at column number in line number of file string

1 Answers  


PLS-00571: method access through data base link not yet supported on client side

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  


ORA-02785: Invalid shared memory buffer size

1 Answers  


ORA-02262: ORA-string occurs while type-checking column default value expression

1 Answers  


Categories