Skip to content
Advertisement

Implicit Data Type Conversion in Oracle

Is the statement true?

Comparison between character value and a number value always implicitly converts the character value to the number data type.

Advertisement

Answer

Yes it’s true.

The manual pretty much contains the same sentence

Implicit Data Conversion

  • When comparing a character value with a numeric value, Oracle converts the character data to a numeric value.
User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement