Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00620: type mismatch found at 'string' among operands in
a COALESCE expression



PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression..

Answer / guest

Cause: In a COALESCE expression, the operands do not match
in datatype, and it is unclear which implicit conversion is
required to correct the mismatch.

Action: Change the operands so that their datatypes match.
Consider using datatype conversion functions in the operands.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12162: TNS:net service name is incorrectly specified

1 Answers  


ORA-38444: statistics do not exist for the expression set

1 Answers  


ORA-09260: sigpidu: error obtaining process id

1 Answers  


PLS-00732: Illegal overload of ellipsis in formal parameter list

1 Answers  


ORA-01146: cannot start online backup - file string is already in backup

1 Answers  






ORA-01237: cannot extend datafile string

2 Answers  


ORA-06954: Illegal file name

1 Answers  


NZE-29111: Invalid index

1 Answers  


ORA-12088: cannot online redefine table "string"."string" with unsupported datatype

1 Answers  


DRG-12408: invalid variable reference: string.string

1 Answers  


ORA-06703: TLI Driver: send break message failed

1 Answers  


ORA-10565: Another test recovery session is active

1 Answers  






Categories